Configure SQL*PLUS

Introduction:

There are a few preferences I have for the way that SQL*PLUS functions.

Aim:

Set up SQL*PLUS configuration.

Requirements:

Oracle is up and runnng.

Procedure:

• Log in to Linux as oracle.
• Open Terminal.
• $ cd $ORACLE_HOME/sqlplus/admin
• $ vi glogin.sql
• Go to the end of the file: G
• Add the folowing lines:
• -- Default editor.
• define _editor=vi
• -- Default pagesize
• set pagesize 1000
• Save and exit.

Testing:

• $sqlplus system/*********
• SQL> select table_name from dba_tables;
• Column headings appear every 1000 lines.
• SQL> ed
• The select statement appears in a vi editor window.