Return to Snippet

Revision: 4845
at January 23, 2008 14:13 by thecrumb


Initial Code
select col.table_name
,col.column_name
,col.data_type
,col.data_default
,col.nullable
,case when col.data_type = 'varchar2' then col.data_length else null end as    data_length
,com.comments
from user_col_comments com
	join  user_tab_cols col
	on       com.table_name=col.table_name
	and com.column_name=col.column_name
order by col.table_name, col.column_id

Initial URL

                                

Initial Description
Get all my columns and comments.

Initial Title
Get Columns and Comments (Oracle)

Initial Tags
sql, Oracle

Initial Language
SQL