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 whole

possible to set continuation prompt in sql*plus?

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

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

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 sid of

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 username the

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

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 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

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, July

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

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

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

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

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

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

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

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

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

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