Moodle Features Demo course does not restore cleanly to Oracle

The Moodle features demo course does not restore cleanly to Oracle.

The main problem has to do with explicit comparisons between CLOBs and text that are performed to avoid duplicate records. Oracle does not support something as simple as

SELECT id FROM table WHERE clobcolumn = 'sometext';

Upon this, it barfs with "ORA-00932: inconsistent datatypes: expected - got CLOB"

Instead, we have to do

SELECT id FROM table WHERE clobcolumn LIKE 'sometext';

with the added inconsistency that under MySQL LIKE is case-insensitive. It is case-sensitive everywhere else.

There are additional problems with hotpot and quoting.