Oracle Special Characters

Question

I have a request

select * from table where name in ('52 T&M', '60 T&M');

"&" causes the request to wait for the parameter. How can I qualify "&"? in a bite request so that the query can find the string using the "&" character in them?

Answer 1

I would usually use set define offas suggested by omg, but you can also do it like this:

select *
from table
where name in ('52 T'||Chr(38)||'M', '60 T'||Chr(38)||'M');

Answer 2

Ampersand ("&") is the character interpreted by SQLPlus as a placeholder variable. Using:

SET DEFINE OFF

Answer 3

, sqlplus,