Search View code

[cassiusdrow]

I'm using the "Find Database Objects" window to search all of the code objects and it is executing the views with "SELECT * FROM viewname". Some of our views are not designed to be used without a WHERE clause and the search will not complete. Is there any way to search the code of views without performing a SELECT on the view?

 

[Marco Kalter]

You can go to Tools > Preferences > Oracle / Options and change the "Add column alias list for views" from "Auto" to "Always" or "Never", depending on how you use view column aliases.

As a result, PL/SQL Developer no longer needs to describe the view SQL, which can improve performance.