SELECT user_id as username,password,enabled
FROM users
WHERE user_id = ?
SELECT users.user_id as username,authority
FROM users,authority,role,user_role,role_auth
WHERE users.user_id =?
AND users.user_id = user_role.user_id
AND role.role_id = user_role.role_id
AND role.role_id = role_auth.role_id
AND authority.auth_id = role_auth.auth_id
上面是MySql的sql语句
帮帮忙把他翻译成等效的Oracle的SQL语句啊多谢
好像和SQL没什么不一样的啊