title: Oracle select rows above and below condition
body: <p>I'm selecting a certain value from an Oracle database. Once I select the value from the table is it possible to get the values directly above and below the one that I selected? If so, whats the best way to go about that? Have something like:</p>
  
  <pre><code>SELECT *
   FROM table_name
    WHERE name = 'F100'
  </code></pre>
  
  <p>So I would like to also select the values directly above and below 'F100' in the table</p>
  
  <p>Data:</p>
  
  <pre><code>ID  | Name
  123 | F300 &lt;-
  123 | F100 &lt;-
  123 | F700 &lt;-
  123 | F900
  123 | F860
  129 | F654
  129 | F700 &lt;-
  129 | F100 &lt;-
  129 | F320 &lt;-
  129 | F790
  </code></pre>