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 vote379 views1 answer
How to remove identity from a column in sql server
SQL
-1 vote357 views3 answers
Psql get last rows
SQL
0 vote384 views1 answer
Sql sum if
SQL
4 votes407 views1 answer
Mysql query first character
SQL
0 vote380 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote357 views1 answer
Create date sql
SQL
0 vote340 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
1 vote349 views1 answer
T-SQL Alter the column data type
SQL
0 vote360 views1 answer
Copy Table from SQL to CSV
SQL
0 vote350 views1 answer
Min salary in sql
SQL