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 vote333 views1 answer
PGSQL dynamic table name
SQL
0 vote257 views1 answer
Now() -1 mysql
SQL
0 vote588 views1 answer
How to connect .sql data set to powerbi
SQL
3 votes288 views1 answer
Sql datetime as date
SQL
0 vote306 views1 answer
Ubuntu connect to mssql database
SQL
0 vote302 views1 answer
Show table details postgresql
SQL
0 vote274 views1 answer
Is not null postgresql
SQL
2 votes307 views1 answer
Sql update \
SQL
0 vote290 views1 answer
Jooq replace
SQL
0 vote289 views1 answer
Mysql money value
SQL