Oracle 8: SQLPLUS login.sql

set pagesize 5000
set linesize 120
set timing on

define_editor="C:\Program Files\Notepad++\Notepad++ -multiInst"

set termout off
column a_prompt new_value the_prompt
select lower(user) || '.' || substr(userenv ('sessionid'), 5) a_prompt from dual;
set sqlprompt &the_prompt.>
column a_prompt clear
clear buffer
undefine the_prompt
set term out on
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s