How to Add Comments to Oracle Views

You can use the following syntax to add field comments to views in Oracle:

COMMENT ON COLUMN view_name.column_name IS 'field_comment';

The view_name is the name of the view, the column_name is the name of the field, and the field_comment is the comment for the field.

For example, if you want to add a comment to the id field in a view named my_view, you can use the following statement:

COMMENT ON COLUMN my_view.id IS 'ID字段用于标识唯一记录';

By using the above statements, you can add comments to fields in the view.