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 vote320 views1 answer
Power bi connect to postgresql
SQL
7 votes135 views1 answer
Sql server convert string to date
SQL
0 vote176 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote139 views4 answers
User defined function sql
SQL
3 votes163 views5 answers
Duplicate table sql
SQL
0 vote189 views1 answer
Sql server is not
SQL
8 votes150 views1 answer
Script to add datafile to tablespace
SQL
0 vote141 views1 answer
Pl/ sql change currency
SQL
0 vote143 views2 answers
Mysql multiply
SQL
0 vote144 views1 answer
Open postgresql.conf in centos
SQL