Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Data-Types

241885Oct 31 2003 — edited Nov 1 2003

I see the Data-types such as VARCHAR in the ALL_OBJECTS view with an OBJECT_TYPE of 'TYPE'. Since these are listed along with other 'TYPE' objects, how to identify the Data-types alone?

Or, are the Data-types stored in some other table? Because, when I query ALL_OBJECTS at home I see the data-types but don't see them at work. Is there an ALL_XXX view where I can retrieve all the data-types?

Thanks in advance...

---
PowerObject!

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 29 2003

Added on Oct 31 2003

#general-database-discussions

3 comments

593 views