Home » SQL & PL/SQL » SQL & PL/SQL » Table/view Report
Table/view Report [message #226118] Thu, 22 March 2007 10:37 Go to next message
Messages: 61
Registered: July 2004
Hello Experts,
Is anybody has any script, which will generate following type or report for all tables/view in oracle database...

Table Name:
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 Go to previous message
Michel Cadot
Messages: 65086
Registered: March 2007
Location: Nanterre, France, http://...
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.

Previous Topic: Row not found for 0 sql
Next Topic: ORA-08177: in a query this dblink
Goto Forum:

Current Time: Tue Jul 25 09:59:58 CDT 2017

Total time taken to generate the page: 0.13929 seconds