Someone sent me a file of ids from one catalog, then I have to hit those ids against another catalog looking for specific conditions. So, all ids will be selected from the picklist, but i'll only get results for those ids that meet the conditions in the second catalog.
As a limitation of Oracle I can only use 1,000 items in a picklist/in statement. Can I create multiple picklists from the same underlying file? That is, if I have a list of 20,000 members in a text file, can I create picklists as follows without having to create 20 text files:
pick1: use rows...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.