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 vote200 views1 answer
Nullif postgresql
SQL
4 votes202 views1 answer
Oracle nls_date_format
SQL
0 vote203 views1 answer
Query builder doctrien return sql
SQL
4 votes185 views1 answer
Find tables with column name in sql
SQL
4 votes319 views1 answer
What are the data types
SQL
7 votes210 views3 answers
Convert ansi sql
SQL
0 vote228 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote189 views1 answer
Initcap in mysql
SQL
0 vote189 views3 answers
Between keyword sql
SQL
1 vote180 views1 answer
Psql filed name alter
SQL