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 vote142 views2 answers
Identity column in sql server
SQL
0 vote129 views1 answer
Excute raw query
SQL
1 vote142 views1 answer
Select random sample sql
SQL
0 vote136 views1 answer
Rabbitmq service not starting
SQL
0 vote134 views1 answer
Sql count null as 0
SQL
0 vote126 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote144 views2 answers
How to update the multiple rows in sql
SQL
0 vote149 views1 answer
Second Step in installing SQL workbench
SQL
6 votes150 views2 answers
Sql sequence
SQL
0 vote149 views1 answer
Is not sql
SQL