这显然是错误的;我不知道你想用这段代码做什么：

WITH    live_str AS (        SELECT ------- from ---------- ),
        pend_str AS     (     SELECT  ----------from -----------),
        pend_only AS ( Select      --------from ---------)

字符串
也许你想做这样的事情？

CREATE OR REPLACE FORCE VIEW "VW_RANGE_REPORT_Jul2023"
AS
   WITH
      live_str
      AS
         (SELECT NVL (lp.storenumber, pp.storenumber) AS storenumber,
                 NVL (lp.storename, pp.storename) AS storename,
                 lp.floorplandbkey AS liveflrkey,
                 lp.floorplanname AS livefloorplanname,
                 lp.flrpenddate AS liveflrpenddate,
                 lp.flrlivedate AS liveflrlivedate,
                 lp.planogramkey AS livepogkey,
                 lp.planogramname AS livepogname,
                 lp.planogrampendingdate AS livepogpenddate,
                 lp.planogramlivedate AS livepoglivedate,
                 pp.floorplandbkey AS pendflkey,
                 pp.floorplanname AS pendfloorplanname,
                 pp.flrpenddate AS pendflrpenddate,
                 pp.flrlivedate AS pendflrlivedate,
                 pp.planogramkey AS pendpogkey,
                 pp.planogramname AS pendpogname,
                 pp.planogrampendingdate AS pendpogpenddate,
                 pp.planogramlivedate AS pendpoglivedate
            FROM live_str  lp
                 FULL OUTER JOIN pend_str pp
                    ON     pp.planogramversionkey = lp.planogramversionkey
                       AND pp.floorplanversionkey = lp.floorplanversionkey
                       AND pp.storenumber = lp.storenumber
                       AND pp.storrdbkey = lp.storedbkey
          UNION ALL
          SELECT po.storenumber,
                 po.storename,
                 NULL AS liveflrkey,
                 NULL AS livefloorplanname,
                 NULL AS liveflrpenddate,
                 NULL AS liveflrlivedate,
                 NULL AS livepogkey,
                 NULL AS livepogname,
                 NULL AS livepogpenddate,
                 NULL AS livepoglivedate,
                 po.floorplandbkey AS pendflkey,
                 po.floorplanname AS pendfloorplanname,
                 po.flrpenddate AS pendflrpenddate,
                 po.flrlivedate AS pendflrlivedate,
                 po.planogramkey AS pendpogkey,
                 po.planogramname AS pendpogname,
                 po.planogrampendingdate AS pendpogpenddate,
                 po.planogramlivedate AS pendpoglivedate
            FROM pend_only po)
   SELECT *
     FROM live_str;

型
另外，您是否确定要将视图名称括在双引号中并在其名称中使用混合字母大小写？你必须这样引用它--使用双引号和匹配字母大小写--每次你使用它。如果我是你我就

CREATE OR REPLACE FORCE VIEW vw_range_report_jul2023

型