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

17 votes292 views2 answers
Mysql date to string
SQL
0 vote310 views1 answer
How to install postgresql on wsl
SQL
0 vote297 views1 answer
Top frequency in sql server
SQL
0 vote386 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
3 votes239 views2 answers
Mysql sum with condition
SQL
1 vote289 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote325 views1 answer
Get total and distict row diff in sql
SQL
1 vote289 views1 answer
Postgres convert date to string
SQL
2 votes326 views1 answer
Oracle Column Names of a table
SQL
0 vote323 views1 answer
Get role postgres
SQL