Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 4th, 2012  |  syntax: None  |  size: 0.41 KB  |  hits: 9  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SET SCAN OFF purpose
  2. old 1: select '&hello' from dual
  3.  new 1: select 'this string was entered' from dual
  4.        
  5. SQL> set scan off;
  6. SQL> ed
  7. Wrote file afiedt.buf
  8.  
  9.   1* select 'foo & bar' from dual
  10. SQL> /
  11.  
  12. 'FOO&BAR'
  13. ---------
  14. foo & bar
  15.        
  16. SQL> set scan on
  17. SQL> /
  18. Enter value for bar: some value
  19. old   1: select 'foo & bar' from dual
  20. new   1: select 'foo some value' from dual
  21.  
  22. 'FOOSOMEVALUE'
  23. --------------
  24. foo some value
create a new version of this paste RAW Paste Data