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!

String to list of number

user6417373Nov 20 2015 — edited Nov 20 2015

I have numbers separated by - and comes out as string. I need that numbers in select statements as list of numbers.

Can someone please help me to get that done?

Example String : "7001-5001-8001"

I have to use this as

select * from table1 where id in ( 7001,5001,8001);

Any help on this will be greatly appreciated.

This post has been answered by jaramill on Nov 20 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2015

Added on Nov 20 2015

5 comments

2,633 views