Alter table add comment oracle

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 vote215 views3 answers
Select top 10 rows in sql
SQL
0 vote185 views1 answer
Import excel to sql
SQL
6 votes173 views3 answers
Mysql change auto_increment start value
SQL
2 votes182 views1 answer
SELECT INTO
SQL
0 vote165 views1 answer
Describe in sqlite3
SQL
12 votes185 views2 answers
Delete entries in postgresql
SQL
0 vote177 views1 answer
Mysql date time string format python
SQL
0 vote180 views1 answer
Format the money fied with comma in international system using sql
SQL
20 votes175 views5 answers
Reset auto increment mysql
SQL
4 votes180 views2 answers
Xampp mysql database server is not starting mac m1
SQL