-
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
-
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.
When the going gets tough, the tough gets going
-
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
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
More Tables
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]
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
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
-
Hi prash,
All_varrays is a feature with oracle 8i. You won't find that with oracle 8.0.5.
thankx
When the going gets tough, the tough gets going
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|