PL/SQL tables,NESTED tables and VARRAY's
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: PL/SQL tables,NESTED tables and VARRAY's

  1. #1
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    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

  2. #2
    Join Date
    Feb 2001
    Posts
    103
    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

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658
    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

  4. #4
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    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

  5. #5
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    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

  6. #6
    Join Date
    Feb 2001
    Posts
    103
    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
  •  



Click Here to Expand Forum to Full Width