Skip to content

Instantly share code, notes, and snippets.

@fibo

fibo/login.sql

Last active December 23, 2015 06:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fibo/6592631 to your computer and use it in GitHub Desktop.
Save fibo/6592631 to your computer and use it in GitHub Desktop.
Download ZIP
sqlplus user profile
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment