daily pastebin goal
1%
SHARE
TWEET

Untitled

a guest Mar 13th, 2018 49 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. define _editor=vi
  2. set serveroutput on size 1000000
  3. set trimspool on
  4. set long 5000
  5. set linesize 100
  6. set pagesize 9999
  7. column plan_plus_exp format a80
  8. column global_name new_value gname
  9. set termout off
  10. define gname=idle
  11. column global_name new_value gname
  12. select lower(user) || '@' || substr( global_name, 1, decode( dot, 0,
  13. length(global_name), dot-1) ) global_name
  14.   from (select global_name, instr(global_name,'.') dot from global_name );
  15. set sqlprompt '&gname> '
  16. set termout on
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top