Code:
oracle@simp:~> echo $SQLPATH
/opt/oracle/scripts/DBA
oracle@simp:~> cd $SQLPATH
oracle@simp:~/scripts/DBA> cat login.sql
set linesize 140
set pagesize 20
set termout off
set feed off
column sqlprompt new_value prompt
column uname new_value username

select user||userenv('sessionid') uname
from dual;

select lower(user)||'@'||global_name||'>' sqlprompt
from global_name;

set editfile /tmp/&username.buf
set sqlprompt &prompt

set termout on
set feed on


oracle@simp:~/scripts/DBA> sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jul 26 09:31:03 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

sys@SIMP>