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

-3 votes333 views8 answers
Sql to c# linq converter online
SQL
9 votes277 views4 answers
How to alter table column name in mysql
SQL
1 vote239 views1 answer
Import database from a file using mysql commandline
SQL
-2 votes260 views1 answer
Group functions in sql
SQL
-1 vote258 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote242 views1 answer
Mysql group by derived column
SQL
0 vote246 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote256 views1 answer
Two inner joins sql
SQL
50 votes312 views4 answers
Sql alter type of column
SQL
0 vote270 views5 answers
Mode sql course
SQL