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 vote353 views1 answer
Select 1 from orders
SQL
4 votes339 views1 answer
Oracle error compilation line
SQL
0 vote306 views1 answer
Mysql find foreign key references
SQL
0 vote365 views1 answer
Display all node label neo4j
SQL
0 vote342 views1 answer
Sqlalchemy case insensitive like
SQL
1 vote375 views1 answer
Sql server select rows by distinct column
SQL
1 vote350 views1 answer
Oracle activate job
SQL
3 votes349 views1 answer
Oracle revoke grant
SQL
2 votes365 views1 answer
Oracle run_duration average
SQL
17 votes344 views6 answers
Sql current date
SQL