ORA-00907: missing right parenthesis

Question

SELECT
*
FROM
(
SELECT
row_.*, ROWNUM row_line
FROM
(
SELECT
*
FROM
(
SELECT
A .*
FROM
(
WITH T AS (
SELECT
SYS_GUID (),
osods.sub_order_type_name,
osods.sub_order_type_id,
oo.business_status_name,
OO.OMS_ORDER_ID,
OSODS.ACTUAL_SKU_QTY,
OSODS.ACTUAL_SKU_VOLUME AS VOLUME,
OSODS.ACTUAL_SKU_WEIGHT AS WEIGHT,
OSODS.STATUS_VALUE_ID,
OSODS.SUB_ORDER_TYPE_ID,
(
CASE
WHEN OSODS.SUB_ORDER_TYPE_ID = 'd1df8a30-09b2-4be1-a265-27165a38b687' THEN
0
ELSE
1
END
) AS ACTION_TYPE
FROM
OMS_ORDER OO,
OMS_SUB_ORD_DTL_STATUS OSODS
WHERE
OO.OMS_ORDER_ID = OSODS.OMS_ORDER_ID
AND OO.ACTIVE = 1
AND OSODS.IS_COMPLETED = 1
AND OO.BUSINESS_STATUS_ID IN (
'ddfc129b-fd6e-46af-b20c-ecea2ccaee18',
'8cac03f4-49be-478d-be9b-ada88b232be9',
'57129ea5-6906-4a0e-b66d-147cc4f81b80',
'11f58dca-9011-4cea-8e93-a94472391812'
)
AND OSODS.SUB_ORDER_TYPE_ID IN (
'd1df8a30-09b2-4be1-a265-27165a38b687',
'9748f0cc-aec7-498f-bce5-f16f78921dfc'
)
AND OSODS.STATUS_VALUE_ID IN (
'02375a2c-686e-4173-90d0-121145aa737f',
'1f6aa98a-a56f-4bb0-afac-667c9b76355e'
)
) SELECT
*
FROM
(
SELECT
OO.OMS_ORDER_ID,
OMS.SERVICE_NAME AS ORDERTYPE,
OO.PROJECT_NAME AS PROCECTNAME,
OO.FOREIGHT_NO AS FOREIGHTNO,
OO.OFFICE_NAME AS OFFICENAME,
OO.EXT_CUSTMER_NAME AS EXTCUSTMERNAME,
OO.SIGN_NO AS SIGNNO,
OO.DESTINATION_PROVINCE_NAME AS PROVINCENAME,
OO.DESTINATION_NAME AS DESTINATIONNAME,
OO.WAREHOUSE_NAME AS WAREHOUSENAME,
OO.ASD AS ASD,
OO.CRD AS CRD,
OO.EXT_COTRACT_NO AS COTRACTNO,
OO.ACTUAL_TOTAL_PIECES AS TOTALPIECES,
OMS.FACT_START_DATE AS MINDATE,
OMS.FACT_END_DATE AS MAXDATE,
OO.ACTUAL_TOTAL_WEIGHT AS TOTALVOLUME,
OO.ACTUAL_TOTAL_VOLUME AS TOTALWEIGHT,
OO.BUSINESS_STATUS_NAME AS STATUSNAME,
NVL (
TRUNC (
(
SYSDATE - OMS.FACT_START_DATE
) * 24,
2
),
0
) AS WRIMTIME,
(
NVL (OMS.PLAN_QTY, 0) - NVL (OMS.ACTUAL_QTY, 0)
) AS UNACTIONQTY,
(
(
SELECT
COUNT (1)
FROM
T TMP
WHERE
TMP.OMS_ORDER_ID = OO.OMS_ORDER_ID
AND TMP.ACTION_TYPE = 0
) - (
SELECT
COUNT (1)
FROM
T TMP
WHERE
TMP.OMS_ORDER_ID = OO.OMS_ORDER_ID
AND TMP.ACTION_TYPE = 1
)
) AS ACTIONQTY,
(
(
SELECT
NVL (SUM(TMP.WEIGHT), 0)
FROM
T TMP
WHERE
TMP.OMS_ORDER_ID = OO.OMS_ORDER_ID
AND TMP.ACTION_TYPE = 0
) - (
SELECT
NVL (SUM(TMP.WEIGHT), 0)
FROM
T TMP
WHERE
TMP.OMS_ORDER_ID = OO.OMS_ORDER_ID
AND TMP.ACTION_TYPE = 1
)
) AS GROSSWEIGHT,
(
(
SELECT
NVL (SUM(TMP. VOLUME), 0)
FROM
T TMP
WHERE
TMP.OMS_ORDER_ID = OO.OMS_ORDER_ID
AND TMP.ACTION_TYPE = 0
) - (
SELECT
NVL (SUM(TMP. VOLUME), 0)
FROM
T TMP
WHERE
TMP.OMS_ORDER_ID = OO.OMS_ORDER_ID
AND TMP.ACTION_TYPE = 1
)
) AS VOLUME
FROM
OMS_ORDER OO,
OMS_MILESTONE_STATUS OMS
WHERE
OO.OMS_ORDER_ID = OMS.OMS_ORDER_ID
AND OO.ACTIVE = 1
AND OO.BUSINESS_STATUS_ID IN (
'ddfc129b-fd6e-46af-b20c-ecea2ccaee18',
'8cac03f4-49be-478d-be9b-ada88b232be9',
'57129ea5-6906-4a0e-b66d-147cc4f81b80',
'11f58dca-9011-4cea-8e93-a94472391812'
)
AND OMS.SERVICE_ID = 'd1df8a30-09b2-4be1-a265-27165a38b687'
AND OMS.STATUS_TYPE = 'CUST OBJECT'
)
WHERE
ACTIONQTY <> 0
) A
AND A .SIGNNO IN ('HTM2011040300457')
)
ORDER BY
WRIMTIME DESC
) row_
WHERE
ROWNUM <= 20
)
WHERE
row_line > 0

Answer 1

按照这个提示是缺失右括号，你这个sql这么复杂，建议你用排除法，把里面的一些语句逐渐的去掉，直到错误消失，就可以定位是哪儿的问题了。