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

2 votes321 views1 answer
Import large .sql files into lampp
SQL
-1 vote295 views2 answers
Sql query examples
SQL
0 vote345 views1 answer
Oracle webcenter content search enginer
SQL
4 votes319 views2 answers
Mysql show indexes on table
SQL
4 votes335 views1 answer
Mysql copy table with new name
SQL
0 vote312 views1 answer
Char varchar nvarchar sql
SQL
-1 vote386 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote317 views1 answer
Mysql drop multiple tables at once
SQL
0 vote353 views1 answer
SQL check if record exist
SQL
2 votes337 views1 answer
Laravel sql String
SQL