Showing posts with label oracle. Show all posts
Showing posts with label oracle. Show all posts

Monday, March 10, 2008

How to display database comments of table's columns

If you want to show the comments of a database tbale's column then try this way.
select * from user_col_comments where table_name='table name'
as same principle.we can show the table's comments:
select * from user_tab_comments where table_name='table name'