Commentaire table oracle

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 vote341 views1 answer
Mysql backup certain tables workbench
SQL
0 vote333 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
-1 vote333 views1 answer
How to switch user in mysql
SQL
0 vote368 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
1 vote483 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote330 views1 answer
Mysql create pool
SQL
0 vote342 views1 answer
Sql select all records from all tables where not empty
SQL
-1 vote317 views1 answer
How to open blade file from blade in laravel
SQL
0 vote340 views1 answer
Copy data from cell to cell mysql
SQL
1 vote312 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL