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 vote178 views1 answer
Mysql select statement after index
SQL
-1 vote155 views1 answer
Sql getdate date only
SQL
1 vote169 views1 answer
Import sql file mysql commadn line
SQL
0 vote196 views1 answer
Sql show founctions
SQL
2 votes174 views2 answers
Enable foreign key checks postgres
SQL
0 vote184 views1 answer
How to get nth number in sql
SQL
0 vote166 views1 answer
Oracle job schedules
SQL
0 vote180 views1 answer
Ajax error exception handeling
SQL
2 votes191 views3 answers
Mysql kill
SQL
2 votes176 views3 answers
Current month mysql query
SQL