Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PLSQL Developer bind variables from GUI like as Oracle SQL Developer

How can I bind variables in PLSQL Developer from GUI like as Oracle PL/SQL Developer?

Example: select :variable from dual; enter image description here

Thanks!

like image 366
Catalin Avatar asked Jan 29 '23 10:01

Catalin


1 Answers

You can execute queries with bind variables inside the "Test Window". It isn't only for debugging: if you type and execute a query, a new tab showing the query results will appear.

The result grid is not as smart as the grid you can use in regular SQL Windows, but it does the job.

Test Window executing a query with bind variables

I did ask multiple times to the Pl/SQL Developers to add support for bind variables to the regular SQL Window but it seems they aren't much interested in doing it

like image 74
Carlo Sirna Avatar answered May 16 '23 07:05

Carlo Sirna