• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Max length of select statement

 
sathiya mohan
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
is there a maximum length of select statement ?
 
Debasis behera
Greenhorn
Posts: 14
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's 64K, according to the Oracle9i Database Reference
 
sathiya mohan
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your reply. will these size get change depending on the database ?. I would like to know for Sql Server and Mysql.
 
Debasis behera
Greenhorn
Posts: 14
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
yes it chages, you goto that database manuals
 
sathiya mohan
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I found the max_allowed_packet for Mysql is 1 GB from the following link,
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html



 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33716
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Keep in mind that there are other limits you may care about such as the number of elements in the "in clause" or the number of where clause elements.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic