Please HELP. Simple PL/SQL

From: <saks1000_at_my-deja.com>
Date: Sat, 24 Jul 1999 00:44:28 GMT
Message-ID: <7nb29b$2ik$1@nnrp1.deja.com>

A quick question. With this construct:

SQL> create or replace type a as object( x integer ) 2 /

Type created.

SQL> create or replace type v_a as varray(20) of REF a 2 /

Type created.

SQL> create or replace type b as object ( m v_a, name varchar) 2 /

Type created.

SQL> create table b_table of b
2 /

Table created.

SQL> How do I list the values of x for a given object b. Say I get 'name' as a parameter.

Thanks.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 23 1999 - 19:44:28 CDT