471,073 Members | 1,279 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

lenth of SQL statement

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 ?
Jul 19 '05 #1
1 3870
"Murty" <ad***@comcast.net> wrote in message news:<cxJib.117899$%h1.124200@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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

28 posts views Thread by Fábio Mendes | last post: by
13 posts views Thread by eman1000 | last post: by
37 posts views Thread by Steven Bethard | last post: by
18 posts views Thread by Steven Bethard | last post: by
28 posts views Thread by Steven Bethard | last post: by
7 posts views Thread by Steven Bethard | last post: by
18 posts views Thread by dspfun | last post: by
1 post views Thread by Murty | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.