Comments for materialzed views

[Mindaugas]

Hi,

as much as i know, comments can be added just for materialized view.

COMMENT ON MATERIALIZED VIEW temp_mv IS Comment .'

;

But in developer, after adding comments to MV using sql command, I edit MV table from table list, and there are no comments. Field is empty.

One more thing, MV containts columns. Again is it possible to add comments for MV columns? In Oracle docs I didn't find such feature.

 

[Marco Kalter]

But in developer, after adding comments to MV using sql command, I edit MV table from table list, and there are no comments. Field is empty.

There is currently no explicit support in PL/SQL Developer for view or materialized view comments. Note that these comments are not the same comments as on the underlying table.

This is on the list of enhancement requests though.

One more thing, MV containts columns. Again is it possible to add comments for MV columns? In Oracle docs I didn't find such feature.

Yes, you can simply execute the following:

comment on column <materialized view name>.<column name> is '<comment>';