Re: Displaying SQL*PLUS buffer?

In article <4dj7v7$29a_at_su102w.ess.harris.com>, tgillesp_at_ms13.mis.semi.harris.com (Tom Gillespie) writes:

>
>Does anyone know of a way to display the contents of the query buffer in
>SQL*PLUS _BEFORE_ I run the query ? I know how to list the buffer AFTER
>I run a query, but I want to display it before the query is executed.
>Turning on spooling just redirects the output, not the buffer contents.
>
>I want to run an SQL script and have the query printed in the log file
>followed by the query's output. (This is real easy to do in Ingres!)
>
>Thanks ahead,
>
>--
> Tom Gillespie - -
> Harris Semiconductor | | | |
> Manufacturing Systems _/\/\/\/
> Palm Bay, FL | | | |
> Tom.Gillespie_at_harris.com _ _
>
> E Pluribus UNIX

Edit the SQL File which has the SQL Script to be Executed. At the First Line Type the Following .....

spool <output_filename>;

set echo on;

< Your SQL Script >

spool off;

Dheena. Received on Tue Jan 23 1996 - 00:00:00 CET