Building on Jacques' solution, here is one that aligns all the statements nice and
neat. Of course, it does not have the username/instance, so I don't know how
acceptable it is
select ' 1 '
as new_prompt
from dual
/
set sqlprompt new_sqlprompt
1 select 1,
2 2,
3 3,
4 4,
Roy,
You got me thinking on a tangent. How can I cut and paste the whole
multi-line SQL
statement at once and have it useable. Now you can, of course, use sqlplus
in silent
mode (-s), but that's a little too silent for my tastes. So how 'bout set
sqlnumber off
sqlprompt ' '. That way you
set sqlprompt ^G
Will make it less quiet.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 23, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Roy,
You got me thinking on a tangent. How can I cut and paste the whole
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:
[EMAIL PROTECTED] select
The command is set sqlprompt.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, July 22, 2003 12:45 PM
To: Multiple recipients of list ORACLE-L
Greetings all,
I've set up my login.sql so that my prompt shows my username the sid of the db to
Sure, just set the following (assuming 9i)
SET SQLNUMBER OFF
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 12:44 PM
Greetings all,
I've set up my login.sql so that my prompt shows my username the sid of
I got the impression that the question is if sql plus has the equivalent of
the Unix PS1, PS2, PS3, PS4 prompts.
-Original Message-
The command is set sqlprompt.
-Original Message-
Greetings all,
I've set up my login.sql so that my prompt shows my username
the
I think so too. I think sqlcontinue and sqlnumber is
what this guy is looking for.
-Original Message-
Sent: Tuesday, July 22, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
I got the impression that the question is if sql plus has the equivalent of
the Unix PS1, PS2, PS3, PS4
That's right--I am looking for an analogue to PSx. 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).
Many thanks to all who responded.
Cheers,
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
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 -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July
: 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
If that's the impression, then no, there's only one, sqlprompt.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, July 22, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
I got the impression that the question is if sql plus has the
. 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
ORACLE-L
Subject: Re: possible to set continuation prompt in sql*plus?
Setting SQLNUMBER OFF will make the SQLPROMPT continuation prompt, not
completely eliminate it.
Isn't it what the OP wanted in the first place?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
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
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
16 matches
Mail list logo