Well that looks like ANSI compatible SQL that should run under Oracle9i. Take a look and the 9i docs to develop a strategy for the "retrofit." This is so weird for me... having to unlearn Oracle syntax in order to write ANSI SQL. Sigh...
-----Original Message-----
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 4:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Win2k/8.1.7/SQL Question
My European customers are trying to optimize some SQL that is
used in their Siebel implementation. It uses a syntax that I
am unfamiliar with. The SQL looks like:
SELECT ...
FROM
SIEBEL.S_PARTY T1
INNER JOIN SIEBEL.S_ORG_EXT T2 ON T1.ROW_ID = T2.PAR_ROW_ID
INNER JOIN SIEBEL.S_ORG_EXT T3 ON T2.MASTER_OU_ID = T3.PAR_ROW_ID
INNER JOIN SIEBEL.S_ACCNT_POSTN T4 ON (T4.POSITION_ID = '1-6M10' 0.05) AND T2.ROW_ID = T4
INNER JOIN SIEBEL.S_PARTY T5 ON (T5.ROW_ID = T4.POSITION_ID, 0.05)
LEFT OUTER JOIN SIEBEL.S_ORG_EXT T6 ON T2.PAR_OU_ID = T6.PAR_ROW_ID
LEFT OUTER JOIN SIEBEL.S_ACCNT_POSTN T7 ON T1.ROW_ID = T7.OU_EXT_ID
LEFT OUTER JOIN SIEBEL.S_ORG_PROMOPRFL T8 ON T2.ROW_ID = T8.ACCNT_ID AND T2.PR_PRFL_ID =
...
WHERE
((T2.INT_ORG_FLG != 'Y' OR T2.PRTNR_FLG != 'N') AND T2.ACCNT_FLG != 'N')
ORDER BY
T2.PRTNR_SALES_RANK
I did a cut-and-paste, so if there is missing punctuation I don't
know that either. Can anyone tell me how this is supposed to
work, or how I can translate into Oracle-compatible SQL?
Thanks,
Mike
