Re: Customize my SQLPlus login
(Oracle 7.3 Windows client) C:\orawin95\PLUS33\GLOGIN.SQL -- -- SQL*Plus Global Login startup file. -- -- This is the global login file for SQL*Plus. -- Add any sqlplus commands here that are to be -- executed when a user invokes sqlplus -- Used by Trusted Oracle column ROWLABEL format A15 -- Used for the SHOW ERRORS command column LINE/COL format A8 column ERRORformat A65 WORD_WRAPPED -- For backward compatibility set pagesize 14 -- Defaults for SET AUTOTRACE EXPLAIN report column id_plus_exp format 990 heading i column parent_id_plus_exp format 990 heading p column plan_plus_exp format a60 column object_node_plus_exp format a8 column other_tag_plus_exp format a29 column other_plus_exp format a44 break on report compute sum of count(*) on report select 'RTFM' from dual; ---end--- ORACLE-L Digest -- Volume 2002, Number 086 -- From: bill thater [EMAIL PROTECTED] Date: Tue, 26 Mar 2002 10:25:12 -0500 Subject: Re: Customize my SQLPlus login [EMAIL PROTECTED] wrote: glogin.sql u... i don't think glogin.sql is on the client PC. well it's not on mine anyway.;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
Eric wrote: -select 'RTFM' from dual; I can't quite get this to work in my version. What version are you using Maybe I need a patch. ;o) Dave -Original Message- Sent: Wednesday, March 27, 2002 1:19 PM To: Multiple recipients of list ORACLE-L (Oracle 7.3 Windows client) C:\orawin95\PLUS33\GLOGIN.SQL -- -- SQL*Plus Global Login startup file. -- -- This is the global login file for SQL*Plus. -- Add any sqlplus commands here that are to be -- executed when a user invokes sqlplus -- Used by Trusted Oracle column ROWLABEL format A15 -- Used for the SHOW ERRORS command column LINE/COL format A8 column ERRORformat A65 WORD_WRAPPED -- For backward compatibility set pagesize 14 -- Defaults for SET AUTOTRACE EXPLAIN report column id_plus_exp format 990 heading i column parent_id_plus_exp format 990 heading p column plan_plus_exp format a60 column object_node_plus_exp format a8 column other_tag_plus_exp format a29 column other_plus_exp format a44 break on report compute sum of count(*) on report select 'RTFM' from dual; ---end--- ORACLE-L Digest -- Volume 2002, Number 086 -- From: bill thater [EMAIL PROTECTED] Date: Tue, 26 Mar 2002 10:25:12 -0500 Subject: Re: Customize my SQLPlus login [EMAIL PROTECTED] wrote: glogin.sql u... i don't think glogin.sql is on the client PC. well it's not on mine anyway.;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
I think you just need to create a script called login.sql in the same directory as you would run SQLPLUS from. Certainly on unix if you login to SQL from a directory that contains a file called login.sql it will process the commands contained within it. HTH Kev. -Original Message- Sent: 26 March 2002 13:38 To: Multiple recipients of list ORACLE-L What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
File login.sql in %Oracle_home%\DBS\ Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Farnsworth, Dave DFarnsworth@AshleyfurTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] niture.com cc: Sent by: Subject: Customize my SQLPlus login [EMAIL PROTECTED] 2002.03.26 15:38 Please respond to ORACLE-L What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
$ORACLE_HOME/sqlplus/admin/glogin.sql On Tue, 2002-03-26 at 07:38, Farnsworth, Dave wrote: What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
glogin.sql Farnsworth, Dave DFarnsworth@AshleyfurTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] niture.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Customize my SQLPlus login [EMAIL PROTECTED] 26-03-2002 14:38 Please respond to ORACLE-L What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Customize my SQLPlus login
glogin.sql -Original Message- Dave Sent: 26 March 2002 13:38 To: Multiple recipients of list ORACLE-L What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
in your oracle /bin directory - you need to alter (Or create) a login.sql file here's what mine looks like - feel free to alter /* start */ set heading on set pause off set pages 23 set lines 100 set verify off set feedback on set space 1 set serveroutput on size 100 set echo off set termout off column d_bname new_value d_bname select user ||'@'||instance_name d_bname from v$instance ; set sqlprompt 'd_bname. ' set termout on set pause on /* end */ Brian. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
Login.sql -Message d'origine- De: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Date: mardi 26 mars 2002 14:38 À: Multiple recipients of list ORACLE-L Objet: Customize my SQLPlus login What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
login.sql and glogin.sql glogin.sql will be global, from wherever you start your sqlplus session, login.sql is run from your current directory so if you have changed directories it won't be run --- Farnsworth, Dave [EMAIL PROTECTED] wrote: What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
Thanks to all who responded!! Dave -Original Message- Sent: Tuesday, March 26, 2002 8:08 AM To: Multiple recipients of list ORACLE-L $ORACLE_HOME/sqlplus/admin/glogin.sql On Tue, 2002-03-26 at 07:38, Farnsworth, Dave wrote: What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
gologin.sql Here's an example from Oracle: -- -- $Header: /plus/v3/spam/precious/files/ACTIVE/glogin.sql,v 1.6 1995/07/25 02:33:26 cjones Exp $ -- Copyright (c) Oracle Corporation 1988, 1994, 1995. All Rights Reserved. -- -- SQL*Plus Global Login startup file. -- -- This is the global login file for SQL*Plus. -- Add any sqlplus commands here that are to be -- executed when a user invokes sqlplus -- Used by Trusted Oracle column ROWLABEL format A15 -- Used for the SHOW ERRORS command column LINE/COL format A8 column ERRORformat A65 WORD_WRAPPED -- For backward compatibility set pagesize 14 -- Defaults for SET AUTOTRACE EXPLAIN report column id_plus_exp format 990 heading i column parent_id_plus_exp format 990 heading p column plan_plus_exp format a60 column object_node_plus_exp format a8 column other_tag_plus_exp format a29 column other_plus_exp format a44 -- Set SQLPLUS Prompt to Database Name column instance_name noprint new_value dbname column passout new_value dbname set term off -- Set default date format Y2K alter session set nls_date_format=DD-MON-; select instance_name, lower(instance_name) passout from gv$instance; set term on set sqlprompt 'dbname' column name print Farnsworth, DaveTo: Multiple recipients of list ORACLE-L DFarnsworth [EMAIL PROTECTED] @Ashleyfurnitcc: ure.com Subject: Customize my SQLPlus login Sent by: root 03/26/2002 08:38 AM Please respond to ORACLE-L What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
However, login.sql will run if it is defined in the SQL_PATH (or possibly SQLPATH) environment variable, which is set up using the same syntax at the normal PATH option, viz. directory names separated by colons. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 26 March 2002 15:30 login.sql and glogin.sql glogin.sql will be global, from wherever you start your sqlplus session, login.sql is run from your current directory so if you have changed directories it won't be run -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
in your current directory put a login.sql file as login.sql -Message d'origine- De: Rodd Holman [mailto:[EMAIL PROTECTED]] Date: mardi 26 mars 2002 15:09 À: Multiple recipients of list ORACLE-L Objet: Re: Customize my SQLPlus login $ORACLE_HOME/sqlplus/admin/glogin.sql On Tue, 2002-03-26 at 07:38, Farnsworth, Dave wrote: What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). login.sql Description: Binary data
RE: Customize my SQLPlus login
I have added some customizations to my glogin.sql. When I start a session of SQLPlus I get this; Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Input truncated to 13 characters SQL show pagesize pagesize 250 I can see that my changes took place but what is the Input truncated to 13 characters about?? Thanks, Dave -Original Message- Sent: Tuesday, March 26, 2002 8:29 AM To: Multiple recipients of list ORACLE-L login.sql and glogin.sql glogin.sql will be global, from wherever you start your sqlplus session, login.sql is run from your current directory so if you have changed directories it won't be run --- Farnsworth, Dave [EMAIL PROTECTED] wrote: What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
Title: RE: Customize my SQLPlus login If you want it set for yourself, but not for everyone, AND need it to take effect from everywhere you run sqlplus, create a login.sql file in some directory under $HOME, and then set $SQLPATH to this directory. Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, but I won when it came to kick boxing. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:29 AM To: Multiple recipients of list ORACLE-L Subject: Re: Customize my SQLPlus login login.sql and glogin.sql glogin.sql will be global, from wherever you start your sqlplus session, login.sql is run from your current directory so if you have changed directories it won't be run --- Farnsworth, Dave [EMAIL PROTECTED] wrote: What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
On solaris, you can set $SQLPATH in your environment and it will look in that path for a login.sql (and any other .sql files that it cannot find in the current directory). -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: 26 March 2002 14:29 To: Multiple recipients of list ORACLE-L Subject: Re: Customize my SQLPlus login login.sql and glogin.sql glogin.sql will be global, from wherever you start your sqlplus session, login.sql is run from your current directory so if you have changed directories it won't be run --- Farnsworth, Dave [EMAIL PROTECTED] wrote: What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
glogin.sql is on my PC but not login.sql. I'm on 9i. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 9:23 AM [EMAIL PROTECTED] wrote: glogin.sql u... i don't think glogin.sql is on the client PC. well it's not on mine anyway.;-) -Original Message- Dave Sent: 26 March 2002 13:38 To: Multiple recipients of list ORACLE-L What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The opposite of a correct statement is a false statement. But the opposite of a profound truth may well be another profound truth. - Niels Bohr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
Put a carriage return at the end of the last line. Farnsworth, Dave wrote: I have added some customizations to my glogin.sql. When I start a session of SQLPlus I get this; Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Input truncated to 13 characters SQL show pagesize pagesize 250 I can see that my changes took place but what is the Input truncated to 13 characters about?? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
[EMAIL PROTECTED] wrote: glogin.sql u... i don't think glogin.sql is on the client PC. well it's not on mine anyway.;-) -Original Message- Dave Sent: 26 March 2002 13:38 To: Multiple recipients of list ORACLE-L What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The opposite of a correct statement is a false statement. But the opposite of a profound truth may well be another profound truth. - Niels Bohr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
Dave, It just needs carriage return at the end of the last line. Iain Nicoll -Original Message- Sent: Tuesday, March 26, 2002 4:18 PM To: Multiple recipients of list ORACLE-L I have added some customizations to my glogin.sql. When I start a session of SQLPlus I get this; Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Input truncated to 13 characters SQL show pagesize pagesize 250 I can see that my changes took place but what is the Input truncated to 13 characters about?? Thanks, Dave -Original Message- Sent: Tuesday, March 26, 2002 8:29 AM To: Multiple recipients of list ORACLE-L login.sql and glogin.sql glogin.sql will be global, from wherever you start your sqlplus session, login.sql is run from your current directory so if you have changed directories it won't be run --- Farnsworth, Dave [EMAIL PROTECTED] wrote: What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
What happens if the user then issues a connect statement to connect to another database? It would be nice if there was a .sql file run every time a new connection is set, I don't know if that is the case in the 8i / 9i versions. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Subject:Re: Customize my SQLPlus login in your oracle /bin directory - you need to alter (Or create) a login.sql file here's what mine looks like - feel free to alter /* start */ set heading on set pause off set pages 23 set lines 100 set verify off set feedback on set space 1 set serveroutput on size 100 set echo off set termout off column d_bname new_value d_bname select user ||'@'||instance_name d_bname from v$instance ; set sqlprompt 'd_bname. ' set termout on set pause on /* end */ Brian. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
not in Oracle_home/sqlplus/admin? It is on mine.. Then again, mine has a database on it as well.. ;) -Original Message- Sent: 26 March 2002 15:24 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wrote: glogin.sql u... i don't think glogin.sql is on the client PC. well it's not on mine anyway.;-) -Original Message- Dave Sent: 26 March 2002 13:38 To: Multiple recipients of list ORACLE-L What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The opposite of a correct statement is a false statement. But the opposite of a profound truth may well be another profound truth. - Niels Bohr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
check sqlplus\admin under ORACLE_HOME --- bill thater [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: glogin.sql u... i don't think glogin.sql is on the client PC. well it's not on mine anyway.;-) -Original Message- Dave Sent: 26 March 2002 13:38 To: Multiple recipients of list ORACLE-L What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The opposite of a correct statement is a false statement. But the opposite of a profound truth may well be another profound truth. - Niels Bohr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
It's possible that you have a line in the file (perhaps the last line) that consists of a string of blanks; or the last command line of the file does not have a carriage return. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 26 March 2002 17:02 I have added some customizations to my glogin.sql. When I start a session of SQLPlus I get this; Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Input truncated to 13 characters SQL show pagesize pagesize 250 I can see that my changes took place but what is the Input truncated to 13 characters about?? Thanks, Dave -Original Message- Sent: Tuesday, March 26, 2002 8:29 AM To: Multiple recipients of list ORACLE-L login.sql and glogin.sql glogin.sql will be global, from wherever you start your sqlplus session, login.sql is run from your current directory so if you have changed directories it won't be run --- Farnsworth, Dave [EMAIL PROTECTED] wrote: What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
Nothing happens, the prompt stays the same unless you run @login, which I do to keep my head straight (INV-SYSTEM)show user USER is SYSTEM (INV-SYSTEM)connect elvis@inv Enter password: * Connected. (INV-SYSTEM)@login (INV-ELVIS) or create a script with the login name and sid that calls login.sql right afterwards. Lisa Koivu Oracle Database Baby Oven. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Customize my SQLPlus login What happens if the user then issues a connect statement to connect to another database? It would be nice if there was a .sql file run every time a new connection is set, I don't know if that is the case in the 8i / 9i versions. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Subject: Re: Customize my SQLPlus login in your oracle /bin directory - you need to alter (Or create) a login.sql file here's what mine looks like - feel free to alter /* start */ set heading on set pause off set pages 23 set lines 100 set verify off set feedback on set space 1 set serveroutput on size 100 set echo off set termout off column d_bname new_value d_bname select user ||'@'||instance_name d_bname from v$instance ; set sqlprompt 'd_bname. ' set termout on set pause on /* end */ Brian. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
I have a custom-coded @connect.sql script that I run instead of the build-in connect statement HOST chmod 600 /tmp/xxx.sql /dev/null 2/dev/null SAVE /tmp/xxx.sql REPLACE CONNECT 1 @login.sql /bin/rm -f /tmp/xxx.sql /dev/null UNDEFINE 1 -Original Message- Sent: Tuesday, March 26, 2002 12:24 PM To: Multiple recipients of list ORACLE-L What happens if the user then issues a connect statement to connect to another database? It would be nice if there was a .sql file run every time a new connection is set, I don't know if that is the case in the 8i / 9i versions. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Subject:Re: Customize my SQLPlus login in your oracle /bin directory - you need to alter (Or create) a login.sql file here's what mine looks like - feel free to alter /* start */ set heading on set pause off set pages 23 set lines 100 set verify off set feedback on set space 1 set serveroutput on size 100 set echo off set termout off column d_bname new_value d_bname select user ||'@'||instance_name d_bname from v$instance ; set sqlprompt 'd_bname. ' set termout on set pause on /* end */ Brian. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
Create yourself a script called connect.sql that looks like: connect 1 @@glogin.sql Keep it in your SQL_PATH just like your glogin.sql. Now when you connect to something else just precede your connect statement with a @ as in: @connect un/pw@db02 Can't be much easier than that. Brian P. MacLean Oracle DBA, OCP8i Boivin, Patrice J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: mpo.gc.ca Subject: RE: Customize my SQLPlus login Sent by: [EMAIL PROTECTED] 03/26/02 10:23 AM Please respond to ORACLE-L What happens if the user then issues a connect statement to connect to another database? It would be nice if there was a .sql file run every time a new connection is set, I don't know if that is the case in the 8i / 9i versions. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 10:23 AM To:Multiple recipients of list ORACLE-L in your oracle /bin directory - you need to alter (Or create) a login.sql file here's what mine looks like - feel free to alter /* start */ set heading on set pause off set pages 23 set lines 100 set verify off set feedback on set space 1 set serveroutput on size 100 set echo off set termout off column d_bname new_value d_bname select user ||'@'||instance_name d_bname from v$instance ; set sqlprompt 'd_bname. ' set termout on set pause on /* end */ Brian. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Customize my SQLPlus login
[EMAIL PROTECTED] wrote: check sqlplus\admin under ORACLE_HOME yup, my bad. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The opposite of a correct statement is a false statement. But the opposite of a profound truth may well be another profound truth. - Niels Bohr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
How do you know you ran the login script?? Maybe you forgot? And your really on production...when your about to truncate that table...that's unrecoverable...that's billions of rowswith hundreds of recent Fairfield customer reservations...that will be very upset... BTW, any chance you can slip me into the system, for a paid hotel reservation in Miami for a couple of days? -Original Message- Sent: Tuesday, March 26, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Nothing happens, the prompt stays the same unless you run @login, which I do to keep my head straight (INV-SYSTEM)show user USER is SYSTEM (INV-SYSTEM)connect elvis@inv Enter password: * Connected. (INV-SYSTEM)@login (INV-ELVIS) or create a script with the login name and sid that calls login.sql right afterwards. Lisa Koivu Oracle Database Baby Oven. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Customize my SQLPlus login What happens if the user then issues a connect statement to connect to another database? It would be nice if there was a .sql file run every time a new connection is set, I don't know if that is the case in the 8i / 9i versions. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Subject: Re: Customize my SQLPlus login in your oracle /bin directory - you need to alter (Or create) a login.sql file here's what mine looks like - feel free to alter /* start */ set heading on set pause off set pages 23 set lines 100 set verify off set feedback on set space 1 set serveroutput on size 100 set echo off set termout off column d_bname new_value d_bname select user ||'@'||instance_name d_bname from v$instance ; set sqlprompt 'd_bname. ' set termout on set pause on /* end */ Brian. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
You don't. It's a habit you have to get into. And it only works if you haven't changed your directory. Like I said you can have another script that has login commands (INV-SYSTEM)@elvis Enter password: * Connected. (INV-ELVIS) My @elvis script is simply this connect elvis@inv @login I can set you up at Hotel Koivu in Ft. Lauderdale for a cheap rate in the dogs cat room. We feature an outdoor pool that is near 80 degrees, tivo, access to antique convertible autos and DSL... but watch out for the very crabby housekeeper :) Lisa Koivu Oracle Database Tank. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Customize my SQLPlus login How do you know you ran the login script?? Maybe you forgot? And your really on production...when your about to truncate that table...that's unrecoverable...that's billions of rowswith hundreds of recent Fairfield customer reservations...that will be very upset... BTW, any chance you can slip me into the system, for a paid hotel reservation in Miami for a couple of days? -Original Message- Sent: Tuesday, March 26, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Nothing happens, the prompt stays the same unless you run @login, which I do to keep my head straight (INV-SYSTEM)show user USER is SYSTEM (INV-SYSTEM)connect elvis@inv Enter password: * Connected. (INV-SYSTEM)@login (INV-ELVIS) or create a script with the login name and sid that calls login.sql right afterwards. Lisa Koivu Oracle Database Baby Oven. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:24 PM To: Multiple recipients of list ORACLE-L Subject:RE: Customize my SQLPlus login What happens if the user then issues a connect statement to connect to another database? It would be nice if there was a .sql file run every time a new connection is set, I don't know if that is the case in the 8i / 9i versions. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Subject:Re: Customize my SQLPlus login in your oracle /bin directory - you need to alter (Or create) a login.sql file here's what mine looks like - feel free to alter /* start */ set heading on set pause off set pages 23 set lines 100 set verify off set feedback on set space 1 set serveroutput on size 100 set echo off set termout off column d_bname new_value d_bname select user ||'@'||instance_name d_bname from v$instance ; set sqlprompt 'd_bname. ' set termout on set pause on /* end */ Brian. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
RE: Customize my SQLPlus login
Put a blank line at the end of your script. I don't know why it does that but that's the fix. Farnsworth, DaveTo: Multiple recipients of list ORACLE-L DFarnsworth [EMAIL PROTECTED] @Ashleyfurnitcc: ure.com Subject: RE: Customize my SQLPlus login Sent by: root 03/26/2002 11:18 AM Please respond to ORACLE-L I have added some customizations to my glogin.sql. When I start a session of SQLPlus I get this; Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Input truncated to 13 characters SQL show pagesize pagesize 250 I can see that my changes took place but what is the Input truncated to 13 characters about?? Thanks, Dave -Original Message- Sent: Tuesday, March 26, 2002 8:29 AM To: Multiple recipients of list ORACLE-L login.sql and glogin.sql glogin.sql will be global, from wherever you start your sqlplus session, login.sql is run from your current directory so if you have changed directories it won't be run --- Farnsworth, Dave [EMAIL PROTECTED] wrote: What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Customize my SQLPlus login
One thing no-one seemed to have mentioned is that login.sql is only processed once. A workaround to this is to have some extra files: connect.sql === conn 1 @login.sql conn.sql (same as above) Then you can use: SQL @conn system/manager system@DEMO hth connor --- Farnsworth, Dave [EMAIL PROTECTED] wrote: What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Customize my SQLPlus login
So Dave, was your question answered? ;) Jared Farnsworth, Dave [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/26/02 09:30 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Customize my SQLPlus login Got it and now it works fine. Thanks everyone. Dave -Original Message- Sent: Tuesday, March 26, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Put a carriage return at the end of the last line. Farnsworth, Dave wrote: I have added some customizations to my glogin.sql. When I start a session of SQLPlus I get this; Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Input truncated to 13 characters SQL show pagesize pagesize 250 I can see that my changes took place but what is the Input truncated to 13 characters about?? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).