Oracle-L: RE: Win2k/8.1.7/SQL Question

From: Adrian Roe <Adrian.Roe_at_telewest.co.uk>
Date: Thu, 16 Jan 2003 02:34:59 -0800
Message-ID: <F001.005310AC.20030116023459@fatcity.com>

Have a look at the SQL Reference guide in the 8i docs. It says that 8i is broadly compatible with the ANSI SQL-99 Core specification, that explains why the SQL listed below works with 8i.

Ade

-----Original Message-----
Sent: 15 January 2003 15:30
To: Multiple recipients of list ORACLE-L

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-----
<mailto:mvergara_at_guidant.com> ]
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

Live Life in Broadband
www.telewest.co.uk

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer.

--

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

Author: Adrian Roe
INET: Adrian.Roe_at_telewest.co.uk

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 Thu Jan 16 2003 - 04:34:59 CST