1、SELECT P.PROCESS_ID,
P.PROCESS_CREATE_DATE,
NVL(C.DICT_NAME, '未知报表类型') AS CYCLE_TYPE_NAME,
R1.WB_ID,
R1.WB_NAME,
U1.USER_ORG
,U1.USER_NAME
FROM REPORT_PROCESS_DEFINITION P
INNER JOIN (SELECT DISTINCT R.REPORT_DEFINITION, S1.WB_ID, S1.WB_NAME
FROM REPORT_DEFINITION R
INNER JOIN (SELECT S.SHEET_WB_ID AS WB_ID,
S.SHEET_ID,
NVL(W.WB_NAME, '未知工作簿') AS WB_NAME
FROM SPREADSHEET_SHEET S
INNER JOIN SPREADSHEET_WORKBOOK W
ON S.SHEET_WB_ID = W.WB_ID
WHERE 1 = 1) S1
ON R.REPORT_SHEET = S1.SHEET_ID) R1
ON P.PROCESS_REPORT_DEFINITION = R1.REPORT_DEFINITION
INNER JOIN (SELECT U.USER_ID,
U.USER_NAME,
NVL(O.ORGANIZATION_NAME, '未知单位') AS USER_ORG
FROM PLATFORM_USER U
LEFT JOIN PLATFORM_ORGANIZATION O
ON U.ORGANIZATION_ID = O.ORGANIZATION_ID
WHERE 1 = 1) U1
ON P.PROCESS_CREATE_USER = U1.USER_ID
LEFT JOIN PLATFORM_DICTIONARY C
ON P.PROCESS_CYCLE_TYPE = C.DICT_ID
WHERE 1 = 1
ORDER BY P.PROCESS_ID, R1.WB_NAME, P.PROCESS_CREATE_DATE
结果:
1 75c8ef00-ac14-4b04-a3b6-875dd56b9c14 22-11月-11 01.05.46.765000 上午 日报 8b592e4d-1bd9-453d-bd78-b7a7f1770913 t37 上海市公安局 用户一
2、
select distinct d.process_id,u.user_name,o.organization_name,w.wb_name,d.process_create_date,w.wb_id,c.dict_name
from REPORT_PROCESS_DEFINITION d,
REPORT_DEFINITION r,
SPREADSHEET_SHEET s,
SPREADSHEET_WORKBOOK W,
PLATFORM_USER U,
PLATFORM_ORGANIZATION O ,
PLATFORM_DICTIONARY c
where d.PROCESS_REPORT_DEFINITION=r.REPORT_DEFINITION
and r.report_sheet=s.sheet_id
and s.sheet_wb_id=w.wb_id
and d.process_create_user=U.USER_ID
AND U.ORGANIZATION_ID=O.ORGANIZATION_ID
and c.dict_id=d.PROCESS_CYCLE_TYPE
结果:
1 75c8ef00-ac14-4b04-a3b6-875dd56b9c14 用户一 上海市公安局 t37 22-11月-11 01.05.46.765000 上午 8b592e4d-1bd9-453d-bd78-b7a7f1770913 日报
两个SQL是否是等价的?
P.PROCESS_CREATE_DATE,
NVL(C.DICT_NAME, '未知报表类型') AS CYCLE_TYPE_NAME,
R1.WB_ID,
R1.WB_NAME,
U1.USER_ORG
,U1.USER_NAME
FROM REPORT_PROCESS_DEFINITION P
INNER JOIN (SELECT DISTINCT R.REPORT_DEFINITION, S1.WB_ID, S1.WB_NAME
FROM REPORT_DEFINITION R
INNER JOIN (SELECT S.SHEET_WB_ID AS WB_ID,
S.SHEET_ID,
NVL(W.WB_NAME, '未知工作簿') AS WB_NAME
FROM SPREADSHEET_SHEET S
INNER JOIN SPREADSHEET_WORKBOOK W
ON S.SHEET_WB_ID = W.WB_ID
WHERE 1 = 1) S1
ON R.REPORT_SHEET = S1.SHEET_ID) R1
ON P.PROCESS_REPORT_DEFINITION = R1.REPORT_DEFINITION
INNER JOIN (SELECT U.USER_ID,
U.USER_NAME,
NVL(O.ORGANIZATION_NAME, '未知单位') AS USER_ORG
FROM PLATFORM_USER U
LEFT JOIN PLATFORM_ORGANIZATION O
ON U.ORGANIZATION_ID = O.ORGANIZATION_ID
WHERE 1 = 1) U1
ON P.PROCESS_CREATE_USER = U1.USER_ID
LEFT JOIN PLATFORM_DICTIONARY C
ON P.PROCESS_CYCLE_TYPE = C.DICT_ID
WHERE 1 = 1
ORDER BY P.PROCESS_ID, R1.WB_NAME, P.PROCESS_CREATE_DATE
结果:
1 75c8ef00-ac14-4b04-a3b6-875dd56b9c14 22-11月-11 01.05.46.765000 上午 日报 8b592e4d-1bd9-453d-bd78-b7a7f1770913 t37 上海市公安局 用户一
2、
select distinct d.process_id,u.user_name,o.organization_name,w.wb_name,d.process_create_date,w.wb_id,c.dict_name
from REPORT_PROCESS_DEFINITION d,
REPORT_DEFINITION r,
SPREADSHEET_SHEET s,
SPREADSHEET_WORKBOOK W,
PLATFORM_USER U,
PLATFORM_ORGANIZATION O ,
PLATFORM_DICTIONARY c
where d.PROCESS_REPORT_DEFINITION=r.REPORT_DEFINITION
and r.report_sheet=s.sheet_id
and s.sheet_wb_id=w.wb_id
and d.process_create_user=U.USER_ID
AND U.ORGANIZATION_ID=O.ORGANIZATION_ID
and c.dict_id=d.PROCESS_CYCLE_TYPE
结果:
1 75c8ef00-ac14-4b04-a3b6-875dd56b9c14 用户一 上海市公安局 t37 22-11月-11 01.05.46.765000 上午 8b592e4d-1bd9-453d-bd78-b7a7f1770913 日报
两个SQL是否是等价的?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货