REM Author : Paresh Mehta
REM Created : June 4, 2004
REM Purpose : Change the look of sql prompt (for 9i).
set echo off
set numwidth 9
set linesize 100
set pagesize 24
Set head off
set time on
set timing on
define _PVMUSRNM=””
column USERNAME new_value _PVMUSRNM;
column name new_value _PVMDBSTR;
select username from user_users;
select name from v$database;
set SQLPROMPT ‘&_PVMUSRNM@&_PVMDBSTR:-> ‘