Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Location
    Argentina
    Posts
    72

    Unanswered: sql plus configuration

    Which file must i edit to configure the linesize so that i must not write SET LINESIZE 1000 each time i open oracle sqlplus.

    I made it once but now i do not remember which is.

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: sql plus configuration

    login.sql

  3. #3
    Join Date
    Oct 2002
    Location
    Argentina
    Posts
    72
    Thanks a ton

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    Or better: ORACLE_HOME\sqlplus\admin\glogin.sql


    --
    -- Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved.
    --
    -- NAME
    -- glogin.sql
    --
    -- DESCRIPTION
    -- SQL*Plus global login startup file.
    --
    -- Add any sqlplus commands here that are to be executed when a user
    -- starts SQL*Plus on your system
    --
    -- USAGE
    -- This script is automatically run when SQL*Plus starts
    --

    -- For backward compatibility
    SET PAGESIZE 14
    SET SQLPLUSCOMPATIBILITY 8.1.7

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

    ....



    Hope that helps,

    clio_usa
    OCP - DBA

    .

  5. #5
    Join Date
    Oct 2002
    Location
    Argentina
    Posts
    72

    Wink

    THanks clio_usa

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •