Information on Columns in Tables

user_tab_columns view has information about the columns. Some of the columns in user_tab_columns:

ColumnTypeDescription
table_nameVARCHAR2(30)Name of the table
column_nameVARCHAR2(30)Name of the column
data_typeVARCHAR2(106)Data type of the column
data_lengthNUMBERLength of the data
data_precisionNUMBERPrecision of a numeric column

SQL> SELECT column_name, data_type, data_length, data_precision, data_scale
  2  FROM user_tab_columns
  3  WHERE table_name = 'MYTABLE';
SQL>
Home »
Oracle »
Table » 

Table Creation:
  1. Creating a Table
  2. Getting Information on Tables
  3. Information on Columns in Tables
  4. Renaming a Table
  5. Truncating a Table
  6. Dropping a Table
Related: