very urgent help needed

[esreddy]

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]

[balajiyes]

this shud work.

select e.startip.a from address e;

u hv to give table alias for obtainin the data.