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
w
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
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 user
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 pr
That's right--I am looking for an analogue to PS. 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
Exte
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, Ju
> -Original Message-
> From: Arup Nanda [mailto:[EMAIL PROTECTED]
> 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 w
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 equivalen
sqlnumber off
> SQL> select *
> SQL> from dual where 1 = 2 ;
> aucune ligne sélectionnée
>
>
> > -Original Message-----
> > From: Arup Nanda [mailto:[EMAIL PROTECTED]
> > Sent: mardi, 22. juillet 2003 12:44
> > To: Multiple recipients of list ORAC
ents of list 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
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:[EMAIL PROTECTED]
> > Sent: mardi, 22. juillet 2003 12:44
&
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
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 whol
15 matches
Mail list logo