RE: Win2k/8.1.7/SQL Question

[Adrian Roe]

Title: RE: Win2k/8.1.7/SQL Question

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-----
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
Sent: 15 January 2003 15:30
To: Multiple recipients of list ORACLE-L
Subject: RE: Win2k/8.1.7/SQL Question

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-----
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 5:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Win2k/8.1.7/SQL Question

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

------------------------------------------------------------------------------
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.


==============================================================================