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 vote180 views1 answer
Object Information
SQL
0 vote187 views1 answer
One table with another
SQL
3 votes194 views2 answers
Tsql join multiple record in one string
SQL
0 vote186 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote198 views1 answer
Oracle execute immediate quotes
SQL
3 votes176 views2 answers
Postgres download
SQL
6 votes281 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
4 votes245 views2 answers
DB::transaction
SQL
0 vote257 views2 answers
Install phoenix
SQL
3 votes203 views2 answers
Mysql import gz
SQL