5

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!

Catalin
  • 253
  • 8
  • 21

1 Answers1

9

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

Community
  • 1
  • 1
Carlo Sirna
  • 1,201
  • 6
  • 11