title: In Oracle SQL, what is a single pipe character ( '|' ) used for?
body: <p>I was studying some dynamic SQL(or perhaps it was regular SQL ?) today in Oracle, when I saw the pipe char being used in a line like this:</p>
  <pre><code>someVar := 'someValue' | 'someOtherValue'
  </code></pre>
  <p>This puzzled me. Is it BITWISE-OR like in TSQL ? Or is it something else?  I am aware of the concatenation operator ( <code>||</code> )  , but it wasn't that one.</p>