Re: bulk select?
Posted by:
timb
Date: September 10, 2004 07:58AM
Try SELECT COUNT( 1 ), 'key_id' FROM 'table' WHERE 'key_id' IN ('id1', 'id2', 'id3') GROUP BY 'key_id'
Not sure how many criteria can go between the brackets for the IN, so you may have to either experiment or do a little research. I've tried as many a couple hundred with no problem.
Subject
Written By
Posted
September 09, 2004 01:16PM
September 10, 2004 06:53AM
Re: bulk select?
September 10, 2004 07:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.