Oracle-L: RE: SQL Plus Environment

From: Koivu, Lisa <Lisa.Koivu_at_efairfield.com>
Date: Tue, 11 Feb 2003 10:59:30 -0800
Message-ID: <F001.00549D35.20030211105930@fatcity.com>

Hi Dave,

Here's how mine is set up (SqlPlus client 8.1.7)

$oracle_home\bin\login.sql, fires when I log in Calls a mylogin.sql file complete with path.

@c:\oracle\ora81\sqlplus\admin\mylogin.sql set linesize 2000
column name format a40
column column format a20

mylogin.sql looks like this

set pause off
set termout off
SET ARRAYSIZE 3
column dbsid new_value dbsid noprint
select global_name dbsid from

global_name;
column dbusr new_value dbusr noprint
select user dbusr from dual;
set sqlprompt '(&dbsid-&dbusr)>'
set termout on
UNDEF DBSID
UNDEF DBUSR set linesize 100
set pagesize 100

HTH, and have a great day. Tell everyone on OT hello.

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117
Fax: 954-935-3639
Cell: 954-683-4459

-----Original Message-----
Sent: Tuesday, February 11, 2003 1:22 PM To: Multiple recipients of list ORACLE-L

I want to set up a glogin.sql and a login.sql. I am reading the manual and I find this. Oh yea. I'm on 8.1.7 on NT.

When you install SQL*Plus, LOGIN.SQL is copied to the DBS subdirectory, and GLOGIN.SQL is copied to the SQLPLUS\ADMIN subdirectory of your Oracle home directory. If you modify LOGIN.SQL or GLOGIN.SQL, make sure you do not add any ANSI escape sequences. See "Setting Up Your SQL*Plus Environment" in Chapter 3 of the SQL*Plus User's Guide and Reference <../../server.817/a82950/toc.htm>, which describes the LOGIN.SQL and GLOGIN.SQL files.

I can find the glogin.sql on my client PC and have edited it to my liking. But I cannot find the login.sql and I do not have the DBS directory. I see a DBS directory on the server but not on the client. Am I missing something or does login.sql not exist on 8.1.7.

Thanks,

Dave

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Farnsworth, Dave
INET: DFarnsworth_at_Ashleyfurniture.com

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Koivu, Lisa
INET: Lisa.Koivu_at_efairfield.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------