Test of SQL for the lazy

[Bo Pedersen]

I like the ability to open a test window for an SQL statement inside a PL/SQL block with the automatic creation of bind variables for the PL/SQL variables.

This ability does also work when debugging the PL/SQL code. But here the PL/SQL variables have a value. So for the lazy developer like me, it would be nice if these values where automatically set for the bind varibles in the new debug session. Then I don't have to copy and paste them from the first debug session.

Bo Pedersen

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[William Robertson]

Wow, didn't realise you could do that! Good tip.

 

[ScottMattes]

fyi, highlight the SQL statement and right click, then select TEST.