Hi,

Sorry if this is a newbie question. But how to get the detailed information about a table in oracle, say if a column has set the defaul value or which column is primary key or set some constraint.

Because when using desc table, you just get column name and column type.

This information is shown by static dictionary views, such as dba_tables, dba_tab_columns, dba_constraints etc.