Access Oracle Tables with alias name

Need Help
1

Hi,

I am trying to connect to Oracle Database, the connectivity is thru. The tables being accessed from the module are “users” and “groups”.
The SQL is built as below, since the alias name for table “User” and “Group” are reserved keywords in Oracle, it is giving an SQL error (ORA-00923).

SELECT User.id, User.username, User.password, User.email, User.em_checked, User.em_key, User.first_name, User.last_name, User.last_login,
User.login_num, User.user_type, User.enabled, User.accept_notes, User.group_id, User.quota_used, Group.id, Group.name FROM users User
LEFT JOIN groups Group ON (User.group_id = Group.id) WHERE User.username = ‘xplico’

Please provide your support in this matter.

2

Not sure, but try set quoteIdentifiers to true on config’s file.
http://book.cakephp.org/3.0/en/orm/database-basics.html