View editor - oracle
Is there any option how to modify the source from a view/materialized view from an editor? Similar functionality is present in the 'Module package editor' with right clicking on the desired package.
Please sign in to leave a comment.
Hello.
When you call the Editor (F4) on a view, you get 2 tabs: Data and Text. The Text is actually an editor with the view definition script. You can change it and press Run button to execute the edited DDL.
However, materialized views are now shown in the tree view as tables, and their generated DDL wrongly assumes a table. Please vote: https://youtrack.jetbrains.com/issue/DBE-620 (Oracle is also affected).
Regards,
Alexander.
Perfect, thanks for the hint.