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 vote381 views1 answer
Sql with example
SQL
3 votes357 views2 answers
Oracle sql select all days between two dates except weekends
SQL
18 votes336 views2 answers
Sql inner join
SQL
2 votes332 views2 answers
Oracle multiple insert
SQL
0 vote342 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
14 votes362 views2 answers
Oracle export trigger ddl
SQL
2 votes362 views2 answers
Sql strip non alphanumeric characters
SQL
1 vote376 views1 answer
Round function in sql oracle
SQL
1 vote390 views1 answer
T-sql find object by name
SQL
19 votes378 views6 answers
Mysql if null
SQL