Re: IDs in IN clause

Robert Wehofer wrote:
> 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

255, documented in the Oracle Reference manual. Please avoid asking questions you could answer easily yourself by consulting the docs.

As you don't specify the source of those id's, no one can tell what the 'best' way is.
If you think you really need to use a temporary table, just create a globabl temporary table.
However, this 'solution' stinks of sqlserver, and should be avoided, as it is sqlserver malpractice ported to Oracle.

-- 
Sybrand Bakker
Senior Oracle DBA