Results 1 to 4 of 4

Thread: set in SQLPLUS

  1. #1
    Join Date
    Mar 2004
    Posts
    11

    Unanswered: set in SQLPLUS

    Hi,
    I am using the set command in SQLPLUS to change the default values for the variables.

    I was wondering if there is any command to set all the SQLPLUS variables back to the default value when I logged in sqlplus.

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Sochaux (France)
    Posts
    55

    Re: set in SQLPLUS

    Originally posted by viranihardik
    Hi,
    I am using the set command in SQLPLUS to change the default values for the variables.

    I was wondering if there is any command to set all the SQLPLUS variables back to the default value when I logged in sqlplus.

    Thanks
    I don't think so, but you can make a file with all your "set" statements and so, run it when you log.

  3. #3
    Join Date
    Nov 2002
    Posts
    833
    you can configure different glogin.sql files for your various purposes

    located in $ORACLE_HOME/sqlplus/admin

  4. #4
    Join Date
    Nov 2003
    Location
    India
    Posts
    114

    Re: set in SQLPLUS

    [To preserve all your settings create a file login.sql and save it in home direcory of Oracle.

    1) edit login.sql -> File will be created in directory from where you are connecting

    2) set your enviroment.

    set lines 100
    set pages 1000
    set feedback 1

    3) Save the file . If you save your file in local directory your settings will be in effect if you login from that direcory. To globalize your settings save your login.sql file in Home direcory of Oracle.

Posting Permissions

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