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

1 vote223 views1 answer
Tsql random number
SQL
2 votes254 views2 answers
How to run postgresql in linux
SQL
0 vote220 views1 answer
Drop check command
SQL
5 votes217 views1 answer
Pl sql asynchronous procedure calls
SQL
1 vote233 views1 answer
Postgresql float 2 decimal places
SQL
0 vote231 views1 answer
Sql server insert inner join
SQL
0 vote215 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote232 views2 answers
Update query with between in mysql
SQL
4 votes226 views1 answer
Postgresql change default value
SQL
2 votes240 views1 answer
Revokeprivileges mysql
SQL