Re: SQLPLUs - How to display output ?

From: <gwong_at_ssbpost.env.gov.bc.ca>
Date: 1995/07/20
Message-ID: <1995Jul20.223341.6802_at_venus.gov.bc.ca>#1/1


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

> azmoodeh_at_netcom.com (Hooman Azmoodeh) writes:
> Stan Novinsky (stan_novinsky_at_jhuapl.edu) wrote:
> : I have a SQLPLUS scriptfile that creates tables. Other than using
> : SET ECHO ON, is there a way to trace the commands that are being
> : executed. Like placing a one line comment within the script that
> : would be displayed as the file executes. Similar to the
> : WRITE SYS$OUTPUT command in a DCL command procedure.....
>
>
> : Thanks
 

> : stan_novinsky_at_jhuapl.edu
 

> :
>
> Not sure if I understand you correctly. But see if this is what you need:
>
> before your command, put in a command explaining what it does like this:
>
> select 'description of what your command does' from dual;
> <<This is your command here>>
>
>
> Hope this helps.
> Mickey,
>
>
>>>> Received on Thu Jul 20 1995 - 00:00:00 CEST

Original text of this message