RE: Win2k/8.1.7/SQL Question

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Wed, 15 Jan 2003 07:29:44 -0800
Message-ID: <F001.00530412.20030115072944@fatcity.com>

I looked at our copy of the 9i Docs, and did some hunting around on the web, and this code definitely looks like 9i SQL. However, the Siebel instance is 8.1.7.3 (or 4...I don't exactly remember). How can they be running this SQL?  

Thanks,
Mike

-----Original Message-----
Sent: Tuesday, January 14, 2003 5:14 PM
To: Multiple recipients of list ORACLE-L

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-----
Sent: Tuesday, January 14, 2003 4:54 PM To: Multiple recipients of list ORACLE-L

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Vergara, Michael (TEM)
  INET: mvergara_at_guidant.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 15 2003 - 09:29:44 CST