Home » SQL & PL/SQL » SQL & PL/SQL » datadictionary / system-view for records (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit)
datadictionary / system-view for records [message #343575] Wed, 27 August 2008 10:02 Go to next message
Burni23
Messages: 1
Registered: August 2008
Junior Member
Hello,

have given a record like:

TYPE name_rec IS RECORD (
first_name VARCHAR2(20),
last_name VARCHAR2(25)
);

Now i search a "system-view" from which i can read the stored records (names and attr.)?

Please help me.

Kind reagards,

Burni23
Re: datadictionary / system-view for records [message #343581 is a reply to message #343575] Wed, 27 August 2008 10:19 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is a PL/SQL type there is no view.
If it is a permanent SQL one:
SQL> l
  1* select * from dict where table_name like 'DBA_%TYPE%'
SQL> /
TABLE_NAME                     COMMENTS
------------------------------ ------------------------------------------------------------
DBA_INDEXTYPES                 All indextypes
DBA_INDEXTYPE_COMMENTS         Comments for user-defined indextypes
DBA_INDEXTYPE_ARRAYTYPES       All array types specified by the indextype
DBA_INDEXTYPE_OPERATORS        All indextype operators
DBA_TYPES                      Description of all types in the database
DBA_COLL_TYPES                 Description of all named collection types in the database
DBA_TYPE_ATTRS                 Description of attributes of all types in the database
DBA_TYPE_METHODS               Description of methods of all types in the database
DBA_SQLJ_TYPES                 Description of all types in the database
DBA_TYPE_VERSIONS              Description of each type version in the database
DBA_SQLJ_TYPE_ATTRS            Description of attributes of all types in the database
DBA_SQLJ_TYPE_METHODS          Description of methods of all types in the database
DBA_ADVISOR_OBJECT_TYPES

13 rows selected.

Regards
Michel
Previous Topic: UTL_FILE - buffer overflow, limit of 2000 bytes
Next Topic: ORA-28546: connection initialization failed, probable Net8 admin error
Goto Forum:
  


Current Time: Fri Dec 09 13:42:55 CST 2016

Total time taken to generate the page: 0.15041 seconds