SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

find_in_set in oracle

685284Feb 29 2012 — edited Feb 29 2012

Hi to all,

What is the equivalent of mysql find_in_set in oracle.

For Ex:

SELECT * FROM USERS WHERE ID IN(2,4,1)

Output should be:

2,4,1

SELECT * FROM USERS WHERE ID IN(4,2,1)

Output should be:

4,2,1

I want output should be based on the order of parameters

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2012

Added on Feb 29 2012

4 comments

5,865 views