That I can do...
--
variable sqlpmpt varchar2(30);
set termout off pause off verify off
declare
username varchar2(30);
instname varchar2(30);
begin
begin
select substr(global_name, 1, instr(global_name||'.', '.')-1)
into instname
from global_name;
exception
when OTHERS then
instname := 'UNK';
end;
begin
select user
into username
from dual;
exception
when OTHERS then
username := 'SQL';
end;
:sqlpmpt := instname||'-'||username||'> ';
exception
when OTHERS then
:sqlpmpt := 'SQL> ';
end;
/
select :sqlpmpt sqlp from dual;
set sqlprompt '&sqlp_var'
column sqlp clear
undefine sqlp_var
undefine sqlpmpt
define _editor=vi
set trimspool on
set pagesize 24
set tab off
set serveroutput on
set termout on
-----Original Message-----
Sent: Tuesday, March 25, 2003 10:35 AM
To: Multiple recipients of list ORACLE-L
Perhaps you could send the contents of your LOGIN.SQL
-----Original Message-----
Sent: Tuesday, March 25, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
Greetings Everyone!
I have a LOGIN.SQL script that I've customized to fit my
preferences. However, when I use SQLPLUS /NOLOG, it fails
miserably since there is no connection to the database.
Is there a way - other than undefining ORACLE_PATH - that the
LOGIN.SQL script can be skipped or ignored when using the
/NOLOG parameter?
Thanks,
Mike
---
===========================================================================
Michael P. Vergara
Oracle DBA
Guidant Corporation
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vergara, Michael (TEM)
INET: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vergara, Michael (TEM)
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
