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 vote317 views1 answer
Radius search with point data in mysql
SQL
0 vote312 views1 answer
OFFSET consulta mysql
SQL
0 vote338 views1 answer
MySQL - Enabling the Event Scheduler
SQL
13 votes320 views2 answers
Sql join 3 tables
SQL
1 vote289 views1 answer
Sql server reseed single table
SQL
5 votes310 views1 answer
Sqlite alter table add column
SQL
1 vote295 views2 answers
Populate sql table with random data
SQL
1 vote330 views2 answers
Foreign key set 0
SQL
0 vote301 views1 answer
Mysql disable query caching
SQL
6 votes289 views1 answer
Sqlite foreign key
SQL