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

1 vote146 views1 answer
Oracle plan hash value
SQL
0 vote141 views1 answer
Convert multiple columns to ROws in sql server
SQL
16 votes142 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote126 views1 answer
Sql if else in select
SQL
0 vote131 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote123 views1 answer
Get only one row in mysql
SQL
7 votes124 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote143 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote129 views1 answer
Less than date query sqlachemy
SQL
1 vote130 views1 answer
Mysql decimal allow negative values?
SQL