thank you so much, i got it
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
[Edited by esreddy on 01-03-2002 at 08:11 AM]
this shud work.
select e.startip.a from address e;
u hv to give table alias for obtainin the data.
Click Here to Expand Forum to Full Width