If we want to give a comment on a table :
COMMENT ON TABLE
If we want to give a comment on a column : COMMENT ON TABLE
The entries of these comments on the table goes in the following tables:
For tables:
select * from all_tab_comments where table_name ='table_name'
(or)
select * from user_tab_comments where table_name = 'table_name'
For Columns
select * from all_col_commentswhere table_name = 'table_name'
(or)
select * from user_col_commentswhere table_name = 'table_name'
1 comment:
i must thank you for the efforts you've put in penning this blog. excellent blog post .
www.n8fan.net
Post a Comment