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 vote262 views1 answer
Sql server cannot create database diagram
SQL
0 vote266 views1 answer
Output table plsql
SQL
0 vote278 views1 answer
Oracle sql alter view add column
SQL
0 vote298 views1 answer
"Hello User Name"
SQL
0 vote253 views1 answer
INSERT INTO table using OpenQuery
SQL
4 votes262 views1 answer
Oracle delete last row
SQL
10 votes285 views4 answers
Drop primary key
SQL
4 votes268 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote275 views1 answer
Pl/ sql change currency
SQL
0 vote278 views1 answer
How to select all fieldsin a soql query
SQL