1

I using Oracle PL/SQL and i need to export all the tables in that database along with their column attributes like column name, type , nullable , default value ,storage , comments

Is there any query be used to pull up this data from database

Thanks in advance

Improve this question

2 Answers 2

Reset to default
1

Using SQLDeveloper: Tools -> Database Export

Exporting Metadata and Data for a Table

enter image description here

Alternatively you can use metadata information and build custom query. Some tips in links below:

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

Describe some system tables for what you ask and much more:

desc all_tab_cols; desc all_tab_comments; desc all_col_comments;

There's also user_tab_cols, etc which are a subset of the above.

Improve this answer

Comments