Answers for "alter table column comments oracle"

SQL
5

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';
Posted by: Guest on June-15-2021

Code answers related to "alter table column comments oracle"

Code answers related to "SQL"

Browse Popular Code Answers by Language