Advanced Search

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