Re: SQLPLUs - How to display output ?

From: Stan Novinsky <stan_novinsky_at_jhuapl.edu>
Date: 1995/07/21
Message-ID: <3uo17k$n9v_at_aplinfo.jhuapl.edu>#1/1

gwong_at_ssbpost.env.gov.bc.ca wrote:

>

> Stan,
>
> To output a comment to the screen, use the SQL*Plus 'PROMPT' command (many of the
> included *.SQL files show examples of this; i.e. under the <OracleHome>\PLUS31 dir).
>
> In addition, you might want to look at the 'SPOOL' command, which spools the output of the
> session into a user-specified text file.
>
> Regards,
> Gary Wong
>
Thanks Gary for the replys. The PROMPT command is what I needed.

Stan     Received on Fri Jul 21 1995 - 00:00:00 CEST