Yes, you can.
SQLEditor supports importing and exporting to Oracle databases and there is a specific Oracle SQL dialect.
SQLEditor will also auto-detect Oracle JDBC drivers when they are installed.
The Oracle driver is available directly from Oracle corporation at their website.
We've done more testing on the Oracle 10g JDBC drivers, however the 11g drivers should work too.The following instructions refer to the 10g drivers. Installation of 11g drivers is similar.
You need to download two files from this page
Both of which then go into /Library/Java/Extensions/
SQLEditor should find these drivers automatically when it starts up.
If SQLEditor is already running you may need to restart it to see the new drivers.
Most Oracle tools seem to create schemas in uppercase although the JDBC driver supports lowercase too.
If you specify a schema in lowercase then you may get an empty document. (depending on your configuration)
There are a number of features in Oracle that have no support in SQLEditor and some features only have partial support. Currently the big features with no support include views, procedures, triggers and namespaces. There are field and table options that aren't supported also.
We are working to increase support for these and other features.
To contact us with a support issue please email: