Oracle-L: RE: Customize my SQLPlus login

From: <tday6_at_csc.com>
Date: Wed, 27 Mar 2002 12:43:25 -0800
Message-ID: <F001.004353CD.20020327124325@fatcity.com>

You need to login as an Oracle userid with the DBA role. (g)

                                                                                           
                    "Farnsworth,                                                           
                    Dave"                To:     Multiple recipients of list ORACLE-L      
                    <DFarnsworth         <ORACLE-L_at_fatcity.com>                            
                    @Ashleyfurnit        cc:                                               
                    ure.com>             Subject:     RE: Customize my SQLPlus login       
                    Sent by: root                                                          
                                                                                           
                                                                                           
                    03/27/2002                                                             
                    03:03 PM                                                               
                    Please                                                                 
                    respond to                                                             
                    ORACLE-L

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 ERROR format 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 <bthater2_at_netscape.net>
>  Date: Tue, 26 Mar 2002 10:25:12 -0500
>  Subject: Re: Customize my SQLPlus login
>
> mark_at_cool-tools.co.uk wrote:
>
> > glogin.sql
>
>
> ummmm... 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: PierceED_at_csus.edu

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: 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.com
--

Author: Farnsworth, Dave
INET: DFarnsworth_at_Ashleyfurniture.com

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

--

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

Author:
INET: tday6_at_csc.com

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