Alter table add comment 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

0 vote345 views2 answers
Android sqlite query join
SQL
0 vote320 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
12 votes347 views2 answers
Find duplicates mysql column
SQL
19 votes341 views6 answers
Sql create table
SQL
-1 vote322 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
10 votes438 views4 answers
Sql server pagination
SQL
1 vote393 views1 answer
Sql server set variable if exists
SQL
0 vote393 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote373 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
1 vote320 views1 answer
Temp table vs variable table in sql server
SQL