CODEWITHSUNDEEP
sqloracle-database
Mercer
Mercer

Reputation: 9986

Oracle error using "in"

Why do I have an error in this query?

My request:

SELECT * FROM CURVES c WHERE c.TYPE_CURVES in ({0}, {10}, {20}, {30})

Error:

ORA-00911 invalid character

Upvotes: 1

Views: 60

Answers (1)

Ben
Ben

Reputation: 52853

Because it should read: 

SELECT * FROM CURVES c WHERE c.TYPE_CURVES in (0)

This is a good site for understanding it.

EDIT

Adding multiple pieces of data...

SELECT * FROM CURVES c WHERE c.TYPE_CURVES in (0,20,30,40)

Or as strings...

SELECT * FROM CURVES c WHERE c.TYPE_CURVES in ('0','20','30','40')

Upvotes: 4

Related Questions