Good way to deal with comma seperated values in oracle
Posted
by dmitry
on Stack Overflow
See other posts from Stack Overflow
or by dmitry
Published on 2010-06-15T20:47:50Z
Indexed on
2010/06/15
20:52 UTC
Read the original article
Hit count: 228
I am getting passed comma seperated values to a stored procedure in oracle. I want to treat these values as a table so that I can use them in a query like:
select * from tabl_a where column_b in (<csv values passed in>)
What is the best way to do this in 11g?
Right now we are looping through these one by one and inserting them into a gtt which I think is ineffecient.
Any pointers?
© Stack Overflow or respective owner