Re: Data Dictionary Info

"Ravinder S Dhillon" <[email protected]>
Newsgroups gmane.comp.db.oracle.devel
Message-ID <LYRIS-1796914-781083-2002.11.27-09.21.45--gcdod-oracle#[email protected]>
hey Nadia


Do these

desc sys.user_types;

adding sys. to these table u have written help u describe them

 Name                            Null?    Type
 ------------------------------- -------- ----
 TYPE_NAME                       NOT NULL VARCHAR2(30)
 TYPE_OID                        NOT NULL RAW(16)
 TYPECODE                                 VARCHAR2(30)
 ATTRIBUTES                               NUMBER
 METHODS                                  NUMBER
 PREDEFINED                               VARCHAR2(3)
 INCOMPLETE                               VARCHAR2(3)

Is this was the thing u were asking about ?

Ravinder



----- Original Message -----
From: "Nadia Pokanov" <[email protected]>
To: "Oracle" <[email protected]>
Sent: Wednesday, November 27, 2002 8:14 AM
Subject: [oracle] Data Dictionary Info


> Hello,
>
> Does anyone have any links thats list and describes the views that let the
> developer get information from the data dictionary?
>
> For eg.
>
> USER_TYPES, USER_TYPE_ATTRS, USER_COLL_TYPES
>
> Thank you,
> Nadia
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or
> to unsubscribe send a blank email to %%email.unsub%%.
>


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.