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

0 vote205 views1 answer
Oracle execute immediate quotes
SQL
0 vote196 views1 answer
Select row with latest date mysql
SQL
0 vote210 views1 answer
Str_to_date sql server
SQL
0 vote203 views1 answer
How to join result table in mysql
SQL
0 vote189 views2 answers
Postgresql get last day of month
SQL
0 vote180 views1 answer
The local psql command could not be located
SQL
0 vote192 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote195 views1 answer
Mysql set variable to today's date
SQL
0 vote191 views1 answer
Show function mysql
SQL
1 vote191 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL