How to query collection type's column?

From: Dong-kyun Son <tenbloodkr_at_hanmir.com>
Date: Tue, 8 Apr 2003 13:45:15 +0900
Message-ID: <b6tk92$nbq$1_at_news.kreonet.re.kr>

i'm using oracle9i..
[Quoted] i want to know how to query about collection index when i use collection type(VARRAY or NESTED TABLE)'s column.

Let me question with sample example.
I created following VARRARY type & table.

SQL> create type author_type as varray(10) of varchar(10); 2 /

Type created.

SQL> create table book (
2 title varchar(10),
3 author author_type);

Table created.

I inserted values(title & 2 authors) into book table.

SQL> insert into book values ('english', author_type('aaa', 'bbb'));

1 row created.

[Quoted] I want to know how to query first author(-->'aaa') or second author(-->'bbb')... (with SQL Statement) Thanks in advance.

---

Received on Tue Apr 08 2003 - 06:45:15 CEST