Maximum Size of Sql query
Hi Gurus...
I need to fire a very large Sql query for some report generation.
Now I want to know wot is the maximum size of sql statement(in bytes or characters) that can be executed in Oracle
Does it depend on any buffer size ?
Is this size configurable ?
Anybody here who can put some light on this topic.
Thanx & Regards
Anurag
Does it holds good with simple sql query( or statements) also.
Thnx chrisrlong & tamilselvan for the information.
tamilselvan,
Wot all limitations u have mentioned are for PL/SQL.
Does it holds good with simple sql query( or statements) also.
Plzz clarify.
Regards
Anurag