sqlplus user profile

login.sql

-- [Gist](https://gist.github.com/fibo/6592631)
--
-- Put this login.sql file in your current dir, or any dir you add to the SQLPATH env var

-- Make SQL prompt show database name so I know where I am (thanks to Tom Kyte for this)
COLUMN global_name new_value gname
SET TERMOUT OFF
SELECT LOWER(USER) || '@' || global_name || '> ' AS global_name FROM global_name;
SET SQLPROMPT '&gname'
SET TERMOUT ON

SET TIME ON
SET PAUSE ON
SET PAGESIZE 80
SET LINESIZE 120