title: BRIDGE command in Oracle SQL Developer
body: <p>Occasionally I need to write queries accessing tables in both an MS Access database and an Oracle database. This can be done in MS Access, but Access limits the SQL I can use and has weird syntax.</p>
  
  <p>The BRIDGE command in SQL Developer sounds perfect for this, but I'm having trouble getting it to work. When trying to execute this:</p>
  
  <pre><code>BRIDGE FallEnrollment2012 AS CentralServer(SELECT * FROM "Fall 2012 Enrollment 10-24-12")
  SELECT * FROM FallEnrollment2012 WHERE ROWNUM &lt;=10
  </code></pre>
  
  <p>I get this error message:</p>
  
  <pre><code>ORA-00900: invalid SQL statement
  00900. 00000 -  "invalid SQL statement"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>Between BRIDGE and FallEnrollment2012 a syntax error is indicated, but I can't figure out what the issue is. As far as I can tell from the examples I've looked at, it's correct as written. Can anyone tell me what I'm doing wrong?</p>