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 vote257 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
1 vote245 views1 answer
Sql update table remove spaces
SQL
1 vote271 views2 answers
Create table if not exist
SQL
1 vote259 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
19 votes271 views5 answers
Date between in mysql
SQL
0 vote290 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote258 views1 answer
No suitable driver found for sqlite
SQL
0 vote295 views1 answer
SQL-Arten
SQL
3 votes287 views1 answer
Create a table with an id in mysql
SQL
-1 vote271 views1 answer
Mysql case when multiple conditions
SQL