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 vote264 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote269 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote287 views1 answer
Postgresql create query
SQL
2 votes297 views1 answer
Oracle insert or update
SQL
0 vote256 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote271 views1 answer
SQL authentication error
SQL
0 vote286 views3 answers
Sql query checker
SQL
0 vote267 views1 answer
Group_concat only returns one row
SQL
1 vote277 views1 answer
Rows to comma separated values in mssql
SQL
1 vote235 views1 answer
Insert into sql
SQL