Edit materialized view from right-click in SQL window

[TomSW]

When I right-click the name of a materialized view I get the option to "View" and "Edit" it, but these take me to the table behind the MV, and the the MV itself, so I can't see the query. Is there a way to get to the MV?
I know I can edit the MV from the object browser, but when I am working with multiple connections, the object browser is often showing objects from another connection.

 

[Marco Kalter]

Did you right-click on the materialized view name in an editor? This opens the view definition when I try it. I can only open the table definition by explicitly right-clicking on it from the Tables folder in the Object Browser.

Can you also let me know your PL/SQL Developer version?

 

[TomOzi]

Thanks! Helpful information!

 

[TomSW]

It works like that for me too.
I have no idea how I got the idea that it didn't - sorry for the confusion!

On the other hand - trying to salvage a valid topic - it would be neat to be able to right-click an MV in the Object Browser Table list and be able to switch the materialized view's context menu (and vice-versa), rather than having to click in the Materialized View list.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

Note that in the Object Browser you can open the "Referenced by" folder of the table to find the materialized view.

Similarly you can open the "References" folder of the materialized view to find the table.