Created
October 11, 2009 01:38
-
-
Save mccxj/207312 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
define _editor=vi | |
set serveroutput on size 1000000 | |
set trimspool on | |
set long 5000 | |
set linesize 100 | |
set pagesize 9999 | |
column plan_plus_exp format a80 | |
column global_name new_value gname | |
set termout off | |
define gname=idle | |
column global_name new_value gname | |
select lower(user) || '@' || substr( global_name, 1, decode( dot, 0, | |
length(global_name), dot-1) ) global_name | |
from (select global_name, instr(global_name,'.') dot from global_name ); | |
set sqlprompt '&gname> ' | |
set termout on |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment