True Bind Variables

[Michael C. Neel]

I'm trying to find how to enable bind variables in PL/SQL developer (i.e. :varname). So far I can only find support for SQL * Plus's substitution variables (i.e. &varname).

For a software developer, substitution variables aren't very helpful since they don't work outside of the editor and will also alter the explain plan making performance issues harder to track down.

 

[IncredibleMrT]

In a test window you can use bind variables xyz) and declare them in the param list lower down. But i'm guessing you mean within direct sql - what about using 'execute immediate'.

 

[Marco Kalter]

You can indeed use the Test Window for this.

 

[Worker]

You can write "direct SQL" in a test window. It doesn't need to be PL/SQL, it can just be a query. SQL output will appear in a new tab.

 

[Michael C. Neel]

Thanks - the test window is what I was looking for.

I don't suppose there is a way to make the variable window a popup like the substitution window and put the SQL Output tab below the Test Script tab? I don't see many options for it in preferences.

 

[mike]

I think you have some good points.

One cool thing someone showed me is if you put the SQL with bind variables in a SQL window, then right click and select test, it will list all of your bind variables in the test window for you. I like that part.