IDs in IN clause

Hello!

Does anyone know, how many IDs are allowed in an Oracle IN clause (Oracle version = 9i)?

e.g: DELETE FROM Table WHERE ID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16, ...)

What is the best way for me to delete amounts of distinct IDs? Is there a way without creating a temporary table to execute:

DELETE FROM Table WHERE ID IN (Select ID FROM TemporaryTable)

Regards,
Robert Received on Wed Jul 12 2006 - 04:16:28 CDT