title: Oracle: "dirname" equivalent string function
body: <p>Given a delimited string in Oracle, what's the most efficient way to drop the last part of the string?  If the string were delimited by "/", it would be functionally equivalent to the unix dirname command.</p>
  
  <pre><code>dirname /foo/bar/baz
  /foo/bar
  </code></pre>