CODEWITHSUNDEEP
sqldatabaseoracle-databaseoracle10g
user1630575
user1630575

Reputation: 171

IN clause not working in oracle

I have a query which uses IN clause and it is not working for below case: 

Select *   
from table1   
where   
Rollno || '/' || UserId IN ('1/001,2/002')

Upvotes: 0

Views: 1139

Answers (2)

Gordon Linoff
Gordon Linoff

Reputation: 1271231

Notulysses has the right syntax for in. But, if you have to deal with a string, you can rephrase this as like:

where ',' || Rollno || '/' || UserId || ',' like '%,' || '1/001,2/002' || ',%'

like is a better approach. Sometimes in the real world, you might have to deal with comma-delimited strings.

Upvotes: 0

potashin
potashin

Reputation: 44611

It is not working because you haven't wrapped each value in single quotes ' :

SELECT *   
FROM table1   
WHERE  Rollno || '/' || UserId IN ('1/001','2/002')

Upvotes: 2

Related Questions