title: Execute scripts by relative path in Oracle SQL Developer
body: <p>First, this question relates to <strong>Oracle SQL Developer 3.2</strong>, not SQL*Plus or iSQL, etc.  I've done a bunch of searching but haven't found a straight answer.</p>
  
  <p>I have several collections of scripts that I'm trying to automate (and btw, my SQL experience is pretty basic and mostly MS-based).  The trouble I'm having is executing them by a relative path.  for example, assume this setup:</p>
  
  <pre><code>scripts/A/runAll.sql
         | /A1.sql
         | /A2.sql
         |
         /B/runAll.sql
           /B1.sql
           /B2.sql
  </code></pre>
  
  <p>I would like to have a file <code>scripts/runEverything.sql</code> something like this:</p>
  
  <pre><code>@@/A/runAll.sql
  @@/B/runAll.sql
  </code></pre>
  
  <p>scripts/A/runAll.sql:</p>
  
  <pre><code>@@/A1.sql
  @@/A2.sql
  </code></pre>
  
  <p>where <code>"@@"</code>, I gather, means relative path in SQL*Plus.</p>
  
  <p>I've fooled around with making variables but without much luck.  I have been able to do something similar using <code>'&amp;1'</code> and passing in the root directory.  I.e.:
  scripts/runEverything.sql:</p>
  
  <pre><code>@'&amp;1/A/runAll.sql' '&amp;1/A'
  @'&amp;1/B/runAll.sql' '&amp;1/B'
  </code></pre>
  
  <p>and call it by executing this:</p>
  
  <pre><code>@'c:/.../scripts/runEverything.sql' 'c:/.../scripts'
  </code></pre>
  
  <p>But the problem here has been that <code>B/runAll.sql</code> gets called with the path: <code>c:/.../scripts/A/B</code>.</p>
  
  <p>So, is it possible <strong>with SQL Developer</strong> to make nested calls, and how?</p>