Re: HP-UX 11i/8.1.7.4/login.sql

From: Chip <ocp-dba_at_earthlink.net>
Date: Wed, 26 Mar 2003 00:28:47 -0800
Message-ID: <F001.00572D7D.20030326002847@fatcity.com>

Personally, I use a modification of Tom Kyte's sql*plus setup from "Expert One-On-One Oracle" (book publisher bankrupt):

• Connect.sql CONNECT &1 UNDEFINE 1 @@Login.sql SET TERMOUT OFF SAVE afiedt.buf REPLACE DEFINE prompt_global_name = SQL COLUMN prompt_global NEW_VALUE prompt_global_name SELECT LOWER(USER)||'@'||SUBSTR(global_name,1,INSTR(global_name,'.')-1) prompt_global FROM global_name / SET SQLPROMPT "&&prompt_global_name>" SET SQLCONTINUE "&&prompt_global_name>" UNDEFINE prompt_global_name CLEAR COLUMN prompt_global SELECT * FROM v$version / SET TERMOUT ON GET afiedt.buf NOLIST
• Login.sql SET ARRAYSIZE 6 SET MAXDATA 60000 SET LINESIZE 132 SET LONG 10000 SET PAGESIZE 1000 SET SERVEROUTPUT ON SIZE 1000000 SET TAB ON SET TRIMSPOOL ON SET TERMOUT ON

In sql*plus I now use @connect user... instead of connect user... The Connect.sql script saves any SQL in the buffer, changes the prompt, displays database version info, and restores the SQL into the buffer. If the connection fails (e.g. bad password), the SQL> prompt appears.

Have Fun :)

Vergara, Michael (TEM) wrote:

>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: Chip
  INET: ocp-dba_at_earthlink.net

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: ListGuru_at_fatcity.com (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).

Received on Wed Mar 26 2003 - 02:28:47 CST