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 vote76 views1 answer
Java spring boot connect to sql server
SQL
0 vote106 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote117 views1 answer
Executescalar in sql server
SQL
12 votes110 views1 answer
How to change the value of a table in sql
SQL
1 vote105 views1 answer
Mysql select row max date
SQL
0 vote105 views1 answer
Sql server set complex constraints
SQL
92 votes295 views6 answers
Substring
SQL
0 vote111 views2 answers
Greater than sql server
SQL
0 vote112 views1 answer
Mssql describe stored procedure sqlcmd
SQL
2 votes114 views1 answer
Sql finding longest and shortest names in a fleld
SQL