Posted By

thecrumb on 01/23/08


sql Oracle

Versions (?)

Get Columns and Comments (Oracle)

 / Published in: SQL

Get all my columns and comments.

  1. SELECT col.table_name
  2. ,col.column_name
  3. ,col.data_type
  4. ,col.data_default
  5. ,col.nullable
  6. ,case when col.data_type = 'varchar2' then col.data_length else NULL end AS data_length
  7. ,com.comments
  8. FROM user_col_comments com
  9. JOIN user_tab_cols col
  10. ON com.table_name=col.table_name
  11. AND com.column_name=col.column_name
  12. ORDER BY col.table_name, col.column_id

Report this snippet  


RSS Icon Subscribe to comments
Posted By: killjim01 on October 18, 2014

red bottom heels oakley sunglasses wholesale chi flat iron,chi hair strighteners toms wedges michael kors sale marc jacobs,marc jacobs handbags,marc jacobs bags,marc jacobs outlet moncler jackets christian louboutin,christian louboutin shoes,christian louboutin outlet fitflop coach outlet stores ugg shoes,uggs for cheap,uggs outlet,uggs for kids,ugg boots sale,uggs sale,uggs on sale,ugg gloves,ugg bailey button,ugg boots cheap,ugg moccasins,uggs canada,uggs for women,fake uggs,ugg boots,ugg uk,ugg boots on sale coach factory outlet coach cyber monday 2014,coach cyber monday,cyber monday 2014,cyber monday deals,cyber monday sales,cyber monday,louis vuitton cyber monday 2014,louis vuitton cyber monday,michael kors cyber monday 2014,michael kors cyber monday

You need to login to post a comment.