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

2 votes165 views2 answers
How to check database username and password in postgresql
SQL
0 vote185 views1 answer
Select year from dual oracle
SQL
0 vote170 views1 answer
Group by 15 minute interval sql server
SQL
1 vote187 views1 answer
Customer using hdfc bank sql query
SQL
0 vote186 views4 answers
Forenkey code alchemy sql
SQL
16 votes186 views3 answers
T-SQL Add Column
SQL
7 votes169 views3 answers
How to check table name in current database sql
SQL
0 vote166 views1 answer
Add timestamp column to existing table ms sql server
SQL
2 votes242 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote165 views1 answer
Query on date sqlite flutter
SQL