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 vote246 views1 answer
How to update date value in sql
SQL
0 vote224 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
6 votes260 views3 answers
Rename column ORACLE
SQL
5 votes225 views1 answer
Oracle sysdate
SQL
0 vote226 views1 answer
Turn on foreign keys check mysql
SQL
0 vote193 views1 answer
Sql server is not
SQL
1 vote225 views1 answer
Oracle apex run 404
SQL
2 votes213 views1 answer
Mysql select random id from table
SQL
0 vote230 views1 answer
Postgresql print variable
SQL
0 vote221 views1 answer
Oracle job schedules
SQL