Organizational Research By

Surprising Reserch Topic

oracle sql how to use more than 1000 items inside an in clause


oracle sql how to use more than 1000 items inside an in clause  using -'I,have,an,SQL,statement,where,I,would,like,to,get,data,of,1200,ep_codes,by,making,use,of,IN,clause.,When,I,include,more,than,1000,ep_codes,inside,IN,clause,,Oracle,says,I'm,not,allowed,to,do,that.,To,overcome,this,,I,tried,to,change,the,SQL,code,as,follows:

SELECT,period,,...
FROM,,,my_view
WHERE,,period,=,'200912'
,,,,,,,...
,,,,,,,AND,ep_codes,IN,(...1000,ep_codes...)
,,,,,,,OR,,ep_codes,IN,(...200,ep_codes...)

The,code,was,executed,succesfully,but,the,results,are,strange,(calculation,results,are,fetched,for,all,periods,,not,just,for,200912,,which,is,not,what,I,want).,Is,it,appropriate,to,do,that,using,OR,between,IN,clauses,or,should,I,execute,two,separate,codes,as,one,with,1000,and,the,other,with,200,ep_codes?

asked Sep 29, 2015 by rolvyrf
edited Sep 29, 2015 by rajesh
0 votes
14 views



Related Hot Questions

5 Answers

0 votes
NULL
answered Sep 29, 2015 by devkumargupta
0 votes
NULL
answered Sep 29, 2015 by sachin valanju
0 votes
NULL
answered Sep 29, 2015 by maurya
0 votes
NULL
answered Sep 29, 2015 by devkumargupta
0 votes
NULL
answered Sep 29, 2015 by girisha

...