oracle comment on view
COMMENT ON TABLE view_name IS 'A view comment';
COMMENT ON COLUMN view_name.MY_COLUMN IS 'A column comment';
SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'VIEW_NAME';
SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'VIEW_NAME';