Show Sid Host User Folder On Prompt

for bash
~/.bashrc

# only current folder name
export PS1='[\u@\h ($ORACLE_SID)\W]$ '
# full current path
export PS1='[\u@\h ($ORACLE_SID)\w]$ '

for sqlplus
~/login.sql

define _editor=vi
set feedback on
set verify on
set termout on
set lines 150
set pages 9999
set trimspool on
set trimterm on
set serveroutput on size 1000000
set sqlprompt &_user(&_connect_identifier)>
set timi on
set time on
set echo on

minimal version

define _editor=vi
set feedback on
set termout on
set lines 150
set pages 9999
set serveroutput on size 1000000
set sqlprompt &_user(&_connect_identifier)>
set timi on
set time on
set echo on