2 ms·
You can directly attach SQLite databases into an Oracle instance via dg4odbc. At this point, you have a much more expansive SQL dialect that you can use to quer
by chasil 4y ago
You can directly attach SQLite databases into an Oracle instance via dg4odbc. At this point, you have a much more expansive SQL dialect that you can use to query your data (I've never tried this in the XE edition, and when it works it can be somewhat brittle and quick to throw errors).
Granted, most databases can do this. However, if you are specifically interested in SQL/PSM, you really can't do better than Oracle.
Fyi, Microsoft/Sybase do not implement SQL/PSM at all; they use Transact-SQL. I've read that IBM db2 is the best implementation outside Oracle, but EnterpriseDB is likely identical.
IBM db2 udb for Unix/Windows happens to have a community edition.
https://www.ibm.com/db2/trials https://www.ibm.com/db2/trials