How to inject a variable in a string in Oracle SQL Developer?

Question

Here is my one of my tries without sucess:

var myVar VARCHAR;
exec :myVar:= 'm';
select * from users where lower(name) like lower(':myVar%')

myVar is the variable i want to inject in the string

Hope to have explained my question well. Thanks in advance.

you cant write a variable in quotes first clear this out.

Himanshu
– Himanshu

2019-02-23 18:09:20 +00:00
Commented Feb 23, 2019 at 18:09 — Himanshu
– Himanshu, Commented Feb 23, 2019 at 18:09

forpas · Accepted Answer · 2019-02-23 16:42:33Z

2

Don't put the variable inside the quotes:

select * from users where lower(name) like lower(:myVar) || '%'

answered Feb 23, 2019 at 16:42

forpas

165k10 gold badges51 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

thatjeffsmith · Accepted Answer · 2019-02-23 17:27:13Z

0

A few things.

var myVar VARCHAR2(2); --varchar2, not varchar
exec :myVar:= 's%'; -- put the wildcard here, it's just easier

select * from employees where lower(first_name) like lower(:myVar)

run everything via F5

answered Feb 23, 2019 at 17:27

thatjeffsmith

22.7k6 gold badges44 silver badges139 bronze badges

1 Comment

Himanshu Over a year ago

This is perhaps very correct because it reduces the seperate concatenation and takes in the input initiallization itself

Collectives™ on Stack Overflow

How to inject a variable in a string in Oracle SQL Developer?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related