Skip to content
Advertisement

How to bind variable in string in SQL query?

I am using SQL Developer. When I want to bind value. Normally I use following syntax:

but, I don’t know how to do that in string. The following query does not work.

Why do I need it? Because my program runs a query in python and assigns something to bind variable:

Advertisement

Answer

Concatenate the prefix/suffix with the bind variable:

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement