Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dictionary table showing all Oraccle data types

Status
Not open for further replies.
dbalearner

dbalearner

Technical User
Aug 23, 2003
170
GB
Is there any dictionary table or view in Oracle that will provde the description of all data types that is available Oracle?

Thanks,

Learner
 
Sort by date Sort by votes
If you mean that literally such as a date variable occupies 7 bytes then no, that is in the manuals. If you mean the structures of the tables then see

all_tab_columns

Bill
Lead Application Developer
New York State, USA
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
738
carp
carp
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
750
carp
carp
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
242
TheLazyPig
TheLazyPig
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
626
carp
carp
LarrySteele
  • Locked
  • Question
Searching multiple fields for any/all words from a search string.
Replies
2
Views
202
LarrySteele
LarrySteele

Part and Inventory Search

Sponsor

Back
Top