Unanswered: how to use a comma separated string in a "IN clause" in oracle
i m passing a comma separated string in my procedure i want to use it in my "IN clause" but i need to convert it in aparticular format to use in my in clause. can u give me a solution for it???????????
my variable is v_string='a,b,c,d'
select * from m_tab where menuid in ('a','b','c','d')
how shud i convert it in this format
'a','b','c','d' to use in my "IN clause"