Environment for SQL*Plus

My login.sql file looks like this. Set SQLPATH to point at it:

set serveroutput on size 1000000 format wrapped

set pagesize 24
set linesize 120
set trimspool on

set termout off
column mysqlprompt new_value m_mysqlprompt
select lower(user) || '@' || lower(global_name) || '>' mysqlprompt from global_name;
set sqlprompt '&m_mysqlprompt'
undefine m_mysqlprompt
set termout on