very urgent help needed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: very urgent help needed

  1. #1
    Join Date
    Oct 2001
    Location
    Hyderabad
    Posts
    44

    Angry thanks

    thank you so much, i got it

    hi,
    i got a problem in sql,i need an immediate help.

    i created a userdefined type as

    "create type ipadd as object (A number, B number);"

    then i create a table as


    create table address (startip ipadd, endip ipadd);

    when i am trying to acces the data like

    >> select startip.ipadd.a from address;

    i am getting error like

    ERROR at line 1:
    ORA-00904: invalid column name


    can any one help me


    thanks


    [Edited by esreddy on 01-03-2002 at 08:11 AM]

  2. #2
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    this shud work.

    select e.startip.a from address e;

    u hv to give table alias for obtainin the data.
    Cheers!
    OraKid.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width