Revision: 4845
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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