Home » RDBMS Server » Server Administration » Data Dictonary
Data Dictonary [message #369374] Thu, 07 September 2000 09:24 Go to next message
bcg
Messages: 4
Registered: September 2000
Junior Member
Hello:

Which system table do I look up for the following info:

Table Name, Column Name, Column data type, column size

Thanks in advnace
BcG
Re: Data Dictonary [message #369377 is a reply to message #369374] Thu, 07 September 2000 12:29 Go to previous messageGo to next message
Daniel Fink
Messages: 2
Registered: September 2000
Junior Member
Check dba_tab_columns.
Re: Data Dictionary [message #369380 is a reply to message #369374] Thu, 07 September 2000 19:15 Go to previous message
Irving
Messages: 13
Registered: September 2000
Junior Member
Hi,

You can also to use the following view:

user_tab_columns

Regards =)
Previous Topic: Error Handling...
Next Topic: Oracle Recovery Concept
Goto Forum:
  


Current Time: Thu Mar 28 12:53:29 CDT 2024