advanced code snippet search

Posted By

thecrumb on 01/23/08


Tagged

sql Oracle


Versions (?)



Get Columns and Comments (Oracle)

Published in: SQL 

Get all my columns and comments.

Expand | Embed | Plain Text 
  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 

Comments

RSS Icon Subscribe to comments
Posted By: Wholesale on March 10, 2010

China Wholesale China Wholesale Wholesale Wholesale China Wholesalers China Wholesalers Wholesale Game Accessories Wholesale Game Accessories Wholesale Iphone Accessories Wholesale Iphone Accessories Video Game Accessories Wholesale Video Game Accessories Wholesale Wholesale Wii Accessories Wholesale Wii Accessories Wholesale Xbox 360 Accessories Wholesale Xbox 360 Accessories Wholesale Xbox 360 Games Wholesale Xbox 360 Games Wholesale Video Gamesv Wholesale Video Games Cheap Video Games Cheap Video Games Cheap Ps3 Games Cheap Ps3 Games Cheap Xbox 360 Games Cheap Xbox 360 Games Wholesale Computers Wholesale Computers Wholesale Laptop Computers Wholesale Laptop Computers Wholesale Laptops Wholesale Laptops Discount Computers Discount Computers Cheap Computers Cheap Computers Wholesale Iphones Wholesale Iphones Wholesale Iphone Wholesale Iphone Wholesale Iphones 3g Wholesale Iphones 3g Hiphones Hiphones Wholesale Hiphone Wholesale Hiphone Wholesale Hiphones Wholesale Hiphones Wholesale Nokia Wholesale Nokia Wholesale Nokia 8800 Wholesale Nokia 8800 Wholesale Nokia n97 Wholesale Nokia n97 wholesale blackberry wholesale blackberry wholesale blackberry phones wholesale blackberry phones wholesale blackberry 9700 wholesale blackberry 9700 wholesale blackberry 9600 wholesale blackberry 9600 wholesale blackberry 9500 wholesale blackberry 9500

You need to login to post a comment.