I'm a SQL Server DBA, and I like to mess around with Oracle here and there.

I can see with select * from information_Schema.columns everything about a table (everything that I need now).

Is there a way to list these informations on a Oracle Schema?


The equivalent in Oracle is user_tab_columns for tables owned by the current user or all_tab_columns for tables accessible to the current user.

| improve this answer | |

In Oracle, you can view such information in Data Dictionary and Dynamic Performance Views.

For information about table columns, you can use the view DBA_TAB_COLS.

select * from dba_tab_cols;
| improve this answer | |
  • Regular users typically do not have access to DBA_xxx views – a_horse_with_no_name Dec 4 '18 at 12:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.