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

6 votes217 views4 answers
Eloquent to sql with bindings
SQL
0 vote232 views1 answer
Mysql bind-address default value
SQL
16 votes219 views4 answers
Mysql import from sql file
SQL
0 vote240 views1 answer
Postgresql print sessions using the database
SQL
2 votes206 views2 answers
Oracle multiple insert
SQL
6 votes219 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
16 votes214 views6 answers
Mysql find and replace
SQL
1 vote219 views1 answer
Backup mysql data only
SQL
2 votes212 views1 answer
Sql like variable
SQL
0 vote209 views1 answer
How to connect postgresql database with java
SQL