PL/SQL tables,NESTED tables and VARRAY's

[pras]

hi everybody
can any body tell me how do i find the list of all the above collection types from the database.any partcular data dictionary where all the information regarding the above collection types.
how do i find the list of types created by a particular user and in which tables they r used as its column datatype.
help is really appreciated.

thanks in advance
pras

[akhil]

Hi Prash,
You can describe the type by using desc "typename". Similarly if you want to know which types,NT and varrays you have created you can use the table User Objects. I hope this will help.

[padmam]

Hi, 25th April 2001 11:09 hrs chennai

USe the following Data Dictionary tables

I)ALL_VARRAYS

II)DBA_COLL_TYPES
==============
This view displays all named collection types in the database such as VARRAYs, nested tables, object tables etc.

Cheers

Padmam

[padmam]

Hi, 25th April 2001 11:17 hrs chennai

More information on Collection types,Nested tables etc.

Use DBA_TABLES
DBA_COLL_TYPES etc.

Also you can further use the following tables

DBA_NESTED_TABLES
DBA_TYPES

Cheers

Padmam

[Edited by padmam on 04-25-2001 at 03:39 AM]

[pras]

Hi
padmam and akhil,
i am able to desc the ALL_COLL_TYPES but when i desc
ALL_VARRAYS it tells me object does not exist.
i am working on 8.0.5
thanks for ur replies
pras

[akhil]

Hi prash,
All_varrays is a feature with oracle 8i. You won't find that with oracle 8.0.5.
thankx