Toad World® Forums

SQL Nav 6.1 Vs SQL Nav 5.5


#1

Hi All,

SELECT COUNT(*)

JOIN ( SELECT ID_OBJECT, SUBCYCLE_VALUE, MAX(DATETIME_SHIFT) PREVIOUS_DATE

WHERE SIMULATION = 0 AND

SUBCYCLE_VALUE IS NOT NULLGROUP BY

) PREV ON ( GEN.ID_OBJECT = PREV.ID_OBJECT AND GEN.SUBCYCLE_VALUE = PREV.SUBCYCLE_VALUE )

GEN.DATETIME_SHIFT = TRUNC(SYSDATE) + 8/24 AND

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

TIA

Francois

I have a SQL Statement that gives me an error (ORA-00907: Missing right parenthesis ). I paste the same statement in the SQL Nav 5.5 and it returns the DATA…

It looks like the problems appear when I’m using virtual table.
Here’s my Statement.

========================================================================
____FROM SCH_SCHEDULE_GENERATION GEN JOIN SCH_OBJECT OBJ ON (GEN.ID_OBJECT = OBJ.ID_OBJECT)FROM SCH_SCHEDULE_GENERATIONDATETIME_SHIFT BETWEEN SYSDATE - 30 AND TRUNC(SYSDATE) ANDID_OBJECT, SUBCYCLE_VALUEWHERE GEN.SIMULATION = 0 AND****GEN.SUBCYCLE_VALUE IS NOT NULL ****


#2

Hi Francois,

This bug causes by the sub-query in the JOIN clause and it has been fixed in our 6.1.1 patch release. You can contact our support team and they will let you know when this patch is available.

Gwen