| Table/view Report [message #226118] |
Thu, 22 March 2007 10:37  |
Daxesh
Messages: 61
Registered: July 2004
|
Member |
|
|
Hello Experts,
Is anybody has any script, which will generate following type or report for all tables/view in oracle database...
Table Name:
Owner:
Table Comment:
==============================================================
Column Name Type Nulls Comment
==============================================================
================================================================
I think this sql will generate the report, but I am not sure how do I format it as above...
select a.owner,a.table_name,b.COLUMN_NAME,b.DATA_TYPE,a.comments
from dba_tab_comments a,dba_tab_columns b
where a.table_name=b.table_name
and a.table_type='VIEW'
and a.table_name like '%'
and a.owner='OWNER_NAME';
Any help would be appreciate...
Thanks again...
|
|
|
|
| Re: Table/view Report [message #226122 is a reply to message #226118] |
Thu, 22 March 2007 10:44  |
 |
Michel Cadot
Messages: 68727
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You already have the query.
As you post in "PL/SQL Experts" I assume you know PL/SQL at least a little bit, so code it, loop on the query/cursor and use dbms_output.put_line to output each line.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
