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.
请先登录再写评论。
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.
Hi there, it seems that this is still an issue. Any plans to resolve it?
Hi Ricardo,
This thread is over 11 years old, and the issue mentioned DBE-620 was fixed long ago. Please create a new ticket so we don’t mix contexts, and describe your issue in more detail.