Oracle

Home 

Configuring Editor for sqlplus client    

 Add the following entry at the end of sqlplus/admin/glogin.sql

	DEFINE _EDITOR=vi
SET EDITFILE /tmp/tmp.sql

 

Configuring sqlplus command line client for Oracle XE

Add the following lines at the end of .bash_profile file.

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=XE

 

bala@bala-desktop:~$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Oct 8 21:29:25 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: bala
Enter password:

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>