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 derfloh 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
Joined
Aug 23, 2003
Messages
170
Location
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

rk68
  • Locked
  • Question Question
Data encryption in Oracle 19c
Replies
0
Views
538
rk68
rk68
George L
  • Locked
  • Question Question
web app not saving "all" records suddenly
Replies
3
Views
1K
carp
carp
TheLazyPig
  • Locked
  • Question Question
Inserting Text Decimal to Table Error
Replies
4
Views
1K
carp
carp
TheLazyPig
  • Locked
  • Question Question
Oracle Data Validation
Replies
4
Views
605
TheLazyPig
TheLazyPig
EM1107
  • Locked
  • Question Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
1K
carp
carp

Part and Inventory Search

Sponsor

Back
Top