Re: lenth of SQL statement

From: <sybrandb_at_yahoo.com>
Date: 14 Oct 2003 00:38:26 -0700
Message-ID: <a1d154f4.0310132338.78e9bd47_at_posting.google.com>


"Murty" <adavi_at_comcast.net> wrote in message news:<cxJib.117899$%h1.124200_at_sccrnsc02>...
> Is there any limit on the maximum length of SQL statement (9i) ?
> Also, is there any limit on the number of items in IN clause ?

Limits like this one are documented in the Oracle Reference Manual. Please look up the manual instead of asking here.

Sybrand Bakker
Senior Oracle DBA Received on Tue Oct 14 2003 - 09:38:26 CEST

Original text of this message