Hello?
Anyone help me please.
SQL> create type phone_t as varray(10) of varchar2(20);
2 /
Type created.
SQL> create type cust_t as object(
2 custno number,
3 custname varchar2(20),
4* phone_list phone_t)
SQL> /
Type created.
SQL> create table cust_tab of cust_t;
Table created.
SQL> insert into cust_tab values (1,'Thomas',phone_t('1234-5678'))
1 row created.
SQL> insert into cust_tab values
(2,'Edison',phone_t('0984-4878','3787-4988','634-4398'));
1 row created.
SQL> commit;
Commit complete.
SQL> select phone_list from cust_tab;
PHONE_LIST
PHONE_T('1234-5678')
PHONE_T('0984-4878', '3787-4988', '634-4398')
==> Here is the question.
I want to get data only.
PHONE_T('1234-5678') ==> 1234-5678
How can I make the query?
mailto:ksjune_at_sys.gsnu.ac.kr
Received on Mon Jul 05 1999 - 05:52:20 CDT