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

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 22 Jul 2003 15:18:47 -0700
Message-Id: <25988.338989@fatcity.com>

You can always set your prompt to take up two lines, but that looks ugly to me too. See example.
SQL> show user
USER est "SYSTEM"
SQL> show sqlprompt
sqlprompt "SQL> "

SQL> -- change prompt to be connected username and last 4
SQL> --  characters of instance name
SQL> column new_prompt new_value new_sqlprompt
SQL> select
  2     user || '@' || chr (10) ||
  3       substr (instance_name, length (instance_name) - 3) || '>'
  4       as new_prompt

  5 from v$instance ;

NEW_PROMPT

---

SYSTEM@
jrk1>

SQL> set sqlprompt "&new_sqlprompt"
SYSTEM@
jrk1>select *
  2 from dual ;

D
-
X

SYSTEM@
jrk1>

> -----Original Message-----
> From: Pardee, Roy E [mailto:roy.e.pardee_at_lmco.com]
>
> Apologies--I wasn't clear in my original post. Right now I'm getting:
>
> rpardee_at_devl> select username
> 2 from dba_users
> 3 where username like '%MC%' ;
>
> What I'd *really* like to have is:
>
> rpardee_at_devl> select username
> 2 from dba_users
> 3 where username like '%MC%' ;
>
> That way I could copy/paste sql commands as easily as I could
> when my prompt was just "SQL> ".
>
> Setting sqlnumber off gets me:
>
> rpardee_at_devl> select username
> rpardee_at_devl> from dba_users
> rpardee_at_devl> where username like '%MC%' ;
>
> Which isn't horrible, although I do miss the numbers. But no
Received on Tue Jul 22 2003 - 17:18:47 CDT