Q] How can I get data only for the ref type in Oracle8?

From: ksjune <ksjune_at_sys.gsnu.ac.kr>
Date: Mon, 23 Aug 1999 17:01:49 +0900
Message-ID: <37C0FFED.21580D63@sys.gsnu.ac.kr>

Hi...
How Can I get data only for the reference type in Oracle8 ?

SQL> select * from personal where name = 'Tom';

NAME ADDR(ADDR_T_ADDRESS) HOMEREF

-------- ---------------------------------
-----------------------------------------------------------------
Tom      ADDR_T('123 Main Street')

A00A0C971685299669D621D4911D3A68A00A0C9716852

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
DEREF(HOMEREF)(HOME_T_TELEPHON)('1-202-202-3030').    But I want to get '1-202-202-3030'

   Thanks.

mailto:ksjune_at_sys.gsnu.ac.kr Received on Mon Aug 23 1999 - 03:01:49 CDT