Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> possible to set continuation prompt in sql*plus?

possible to set continuation prompt in sql*plus?

From: Pardee, Roy E <roy.e.pardee_at_lmco.com>
Date: Tue, 22 Jul 2003 08:43:31 -0700
Message-Id: <25988.338907@fatcity.com>


Greetings all,

I've set up my login.sql so that my prompt shows my username & the sid of the db to which I'm connected. This works well, but has made it tough to drag-select text b/c now the first line sticks way out relative to the continuation lines, like so:

rpardee_at_prod> select username
  2 from dba_users
  3 where username like '%MC%' ;

Is it possible to specify the prompt that shows on continuation lines (or otherwise pad it out) in sql*plus?

Thanks!

-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487 Received on Tue Jul 22 2003 - 10:43:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US