How to extract table definitions using SQL or Toad

Question

Can somebody tell me how to extract my table definitions using SQL? I want to extract the datatypes of all my tables and other information from my Oracle schema. I have about 100 tables.

I need the complete documentation of my Oracle Schema. My schema name IS "cco".

Can I do this by SQL?

I am using Toad for Data analyst 3.3. Please let me know if this tool helps.

Answer 1

You can try this -

select * from all_tab_cols
where owner = 'CCO';