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

2003-07-22 Thread Goulet, Dick
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

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

2003-07-22 Thread Arup Nanda
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

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

2003-07-22 Thread Stephen Lee
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

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

2003-07-22 Thread Richard Ji
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

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

2003-07-22 Thread Pardee, Roy E
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

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

2003-07-22 Thread Arup Nanda
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

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

2003-07-22 Thread Jacques Kilchoer
> -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

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

2003-07-22 Thread Goulet, Dick
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

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

2003-07-22 Thread Arup Nanda
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

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

2003-07-22 Thread Jacques Kilchoer
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

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

2003-07-22 Thread Pardee, Roy E
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 &

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

2003-07-22 Thread Jacques Kilchoer
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

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

2003-07-23 Thread Daniel Fink
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,

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

2003-07-23 Thread Hand, Michael T
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

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

2003-07-23 Thread Gogala, Mladen
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