Change default EDITor in SQL*Plus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Change default EDITor in SQL*Plus

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    14

    Question

    Who knows how to change the default editor for EDIT command?
    --
    Dmitri Don

  2. #2
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    You need to make entry an entry in the sqlplus global login file.
    This file is normally found in $ORACLE_HOME\sqlplus\admin
    Its name is : glogin.sql
    Add any line to this file that you want to be default for SQL*PLUS
    eg to make the unix editor 'vi' the default for SQL add the following line

    def _EDITOR=vi

    Next time you enter sqlplus and type 'ed' the 'vi' editor should start.

    You can also put 'set' commands in this file - so if you want to change
    the default lines per page for add the line set pagesize 25.

    Hope this helps.....

    Moff

  3. #3
    Join Date
    Nov 2000
    Posts
    14

    Smile

    WOW! This is realy cool! And it realy works! Thanks! VI is so much better!!! btw in def_EDITOR no spaces needed after 'def'.

    Thanks!
    --
    Dmitri Don

Posting Permissions

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



Click Here to Expand Forum to Full Width