Oracle create table comment

COMMENT ON TABLE table_name IS 'A table comment';
COMMENT ON COLUMN table_name.MY_COLUMN IS 'A column comment';

SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';
SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';

Similar codes

0 vote368 views1 answer
How to get button for every record from mysql
SQL
0 vote326 views1 answer
How to to get current date in sql
SQL
0 vote308 views1 answer
Select password from user mysql
SQL
0 vote308 views1 answer
First mysql
SQL
0 vote336 views1 answer
Sql query tags
SQL
0 vote356 views1 answer
Select distinct after join
SQL
1 vote300 views1 answer
SQLSTATE[HY000] [2002]
SQL
1 vote366 views1 answer
Oracle see column type
SQL
1 vote333 views1 answer
How to get previous year from sysdate in oracle
SQL
4 votes321 views2 answers
Oracle sql group by date year
SQL