Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Q] 1 more question about OBJECT type
Hi!!!
I have 1 more questions about OBJECT type.
SQL> desc personal;
Name Null? Type -------------------------------- -------- --------------------------- NAME VARCHAR2(10) ADDR ADDR_T HOMEREF REF OF HOME_T
SQL> insert into home_tbl values ( home_t( '1-202-202-3030' ) ); 1 row created.
SQL> insert into personal
2 select pers_t( 'Tom', addr_t( '123 Main Street' ), ref(h) )
3 from home_tbl h
4 /
1 row created.
SQL> commit;
Commit complete.
SQL> select * from personal where name = 'Tom'; NAME ADDR(ADDR_T_ADDRESS) HOMEREF
---------- --------------------------------------- ---------------------------------------------------------------------- Tom ADDR_T('123 Main Street')
SQL> select name, addr,deref(homeref) from personal
2 where name = 'Tom'
NAME ADDR(ADDR_T_ADDRESS) DEREF(HOMEREF)(HOME_T_TELEPHON)
----------- -------------------------------- ------------------------------------------------- Tom ADDR_T('123 Main Street') HOME_T('1-202-202-3030')
Question))
How can I get the only data of query? The result of type is ADDR_T('123 Main Street'). But I want to get '123 Main Street'
Thanks.
mailto:ksjune_at_sys.gsnu.ac.kr Received on Thu Jun 10 1999 - 20:24:55 CDT
![]() |
![]() |