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.

2 comments
Comment actions Permalink

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.

0
Comment actions Permalink

Perfect, thanks for the hint.

0

Please sign in to leave a comment.