RE: possible to set continuation prompt in sql*plus?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 22 Jul 2003 12:02:03 -0700
Message-Id: <25988.338953@fatcity.com>

sqlcontinue changes the prompt for the continuation of a SQL*Plus command, not a SQL command. sqlnumber off will mean that instead of having number prompts on the continuation of a SQL statement the SQL prompt will be continued (which I personally find annoying).

set sqlnumber off should eliminate the problem of the "indented first line", but you won't get a continuation prompt at all.

Example (using SQL*Plus 8.1.7):
SQL> -- continuation of a SQL*Plus command. SQL> prompt -
> Hello World

Hello World
SQL> set sqlcontinue "Next> "
SQL> prompt -
Next> Hello World
Hello World

SQL> -- +++++++++++++++++++++++++++++++++++++++

SQL> -- continuation of a SQL command
SQL> select *
  2 from dual where 1 = 2 ;
aucune ligne sélectionnée

SQL> set sqlnumber off
SQL> select *
SQL> from dual where 1 = 2 ;

aucune ligne sélectionnée

> -----Original Message-----
> From: Arup Nanda [mailto:orarup_at_hotmail.com]
> Sent: mardi, 22. juillet 2003 12:44
> To: Multiple recipients of list ORACLE-L
> Subject: Re: possible to set continuation prompt in sql*plus?
>
>
> I suggested using SET SQLNUMBER OFF. This sure works in
> SQL*Plus 8i and
> above; not sure if it does in 8.0.6 and I don't have a test
> executable to
> test it. But have you tried it?
>
> Arup Nanda
> ----- Original Message -----
>
> > That's right--I am looking for an analogue to PS<x>. I've
> been playing
> around w/sqlcontinue & sqlnumber but so far no joy. I'm
> using sql*plus
> 8.0.6.0.0 (running against an 8.1.6 db).
Received on Tue Jul 22 2003 - 14:02:03 CDT