下面的查询在 MYSQL 数据库。

select * from accounts where preferred_email like "%p.rajesh%";
select * from account_external_ids where external_id like "%p.rajesh%";

我们有 Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit 当我试着在错误下面跑的时候。

select * from accounts where preferred_email like '%p.rajesh%';
ERROR: ORA-00933: SQL command not properly ended

select * from account_external_ids where external_id like '%p.rajesh%';
ERROR: ORA-00933: SQL command not properly ended

看起来甲骨文不处理分号。我是oracle的新手，你能帮我在oracle中运行以上mysql查询吗？