alter table add comment oracle

Solutions on MaxInterview for alter table add comment oracle by the best coders in the world

showing results for - "alter table add comment oracle"
Edoardo
30 Jan 2018
1COMMENT ON TABLE table_name IS 'A table comment';
2COMMENT ON COLUMN table_name.MY_COLUMN IS 'A column comment';
3
4SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';
5SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';