Re: How to handle large SQL statements in Oracle ??

On Wed, 4 Feb 1998 17:36:10 -0800, Michael Zhao <mizhao_at_cisco.com> wrote:

Hi Michael,

why don't you store your statement in a text file?

then issue @<path><text file> at SQLPlus-prompt to execute.

set echo on and spool to a second text file to inspect the result(s) of your statement.

>
>Hi,
>
>I am bulding a large SQL statements ( ~ 10KB ) which can't be processed by
>Orcale sqlplus. Does anyone know how to increase Oracle SQL statement
>buffer in sqlplus?
>
>Thanks!
>
>-Michael Zhao @Cisco
>
Received on Thu Feb 05 1998 - 00:00:00 CST