On 3 Nov 2016, at 8:00am, Christoph P.U. Kukulies <k...@kukulies.org> wrote:
> How close to Oracle's PL/SQL can Sqlite be? Are there pragmas allowing for > this? Or is there a matrix showing the differences? I believe the only difference matrix in the whole SQLite documentation at the moment is the one on <https://www.sqlite.org/nulls.html> which is for one small piece of SQL. In cases where different SQL engines do different things, and each one is equally simple and easy to implement, SQLite generally does was PostgreSQL does. But this is not true for all cases. SQLite is not an emulator for any other SQL engine and there are no PRAGMAs which change its behaviour in general to resemble any other SQL engine. You should definitely not take a program written for Oracle's peculiarities and try to make it work with SQLite unchanged. However changes you make for SQLite may not prevent your SQL code from working with Oracle. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
