Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Posts
    64

    Question Unanswered: sql * plus settings

    Hi ,

    Whenever i am opeening my sq; * plus session i have to set the below mentioned variables in order to use it comfortably :-
    set linesize 30000
    set pagesize 30000
    set sqlprompt PRODA>

    but rather typing it everytime i open a new sesion i have created a sql file having these settings and i am openning the file using the editor but it is not changing the settings.

    PFA the screenshot.

    Please advice

    Subhotech
    Attached Thumbnails Attached Thumbnails sql_plus.JPG  

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Put all those settings into a LOGIN.SQL file (which should be in a directory you use when connecting to SQL*Plus). Alternatively, to use it always, create a GLOGIN.SQL file ("global") (it should be located in your ORACLE_HOME\SQLPLUS\ADMIN directory).

    Google for more information.

  3. #3
    Join Date
    Jan 2010
    Posts
    64

    Thanks for the help !!

    Thanks! for the info ....i did some google found some more info..
    Actually i am working on a remote machine and i dont have access to Oracle installation directory.i.e ADMIN etc
    So i have stored the current setting into a file using STORE SET FILE_NAME which stores all the env variables and then i modiefied the variables . On logging to a new session i can use START FILE_NAME TO use the new settings.

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by subhotech View Post
    Thanks! for the info ....i did some google found some more info..
    Actually i am working on a remote machine and i dont have access to Oracle installation directory.i.e ADMIN etc
    You don't need access to the Oracle installation.

    login.sql is stored locally on your computer where you run SQL*Plus

    See the manual for details

    http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch2.htm#sthref410

Posting Permissions

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