在SQL中有如下语句,请问在Oracle中应该如何写?(有哪位有SQL和ORACLE之间SQL文变换的资料啊?帮忙提供一下!)
SELECT A.MBR_CODE,A.MBR_NAME,DEP.DEP_CODE,DEP.DEP_ALIAS
FROM T_MEMBER A,T_DEPARTMENT DEP,T_ATTACHED ATT,T_POST POS
WHERE A.MBR_UID = ATT.MBR_UID
AND ATT.POST_UID *= POS.POST_UID
SELECT A.MBR_CODE,A.MBR_NAME,DEP.DEP_CODE,DEP.DEP_ALIAS
FROM T_MEMBER A,T_DEPARTMENT DEP,T_ATTACHED ATT,T_POST POS
WHERE A.MBR_UID = ATT.MBR_UID
AND ATT.POST_UID *= POS.POST_UID
FROM T_MEMBER A,T_DEPARTMENT DEP,T_ATTACHED ATT,T_POST POS
WHERE A.MBR_UID = ATT.MBR_UID
AND ATT.POST_UID(+)= POS.POST_UID