php - how to extend the maximum number of expression in a list of oracle? -
this question has answer here:
i using in clause, whereby, needs search id in these set of ids not in order, meaning, came different criteria., how solve ?
select distinct id "projeck"."mytable" "t" staffid in (75953,196262,196387,133585,195639,196702,195790,195820,192903,145383,179603,175896,176554,43545,154843,183798,195767,195715,etc..etc.. etc..)
and getting oracle error
general error: 1795 ocistmtexecute: ora-01795: maximum number of expressions in list 1000
my first choice reference function generates these values directly.
if values being used multiple queries , expensive calculate i'd think loading them global temporary table , joining it.
Comments
Post a Comment