The Parser did not identify the text as a valid SQL statement. SELECT ‘TCO Active’ AS TYPE, DECODE( ecs.REQUEST_TYPE_ABBR, ‘CONSIT’, ‘Consumer’, ‘LTSPEED’, ‘Consumer’, ‘SOLINT’, ‘Consumer’, ‘ITO’, ‘ITO’, ‘Enterprise’) || ‘-’ || Team$.“Supervisor” AS BU, DECODE( ecs.REQUEST_TYPE_ABBR, ‘CONSIT’, ‘Consumer’, ‘LTSPEED’, ‘Consumer’, ‘SOLINT’, ‘Consumer’, ‘ITO’, ‘ITO’, ‘Enterprise’) AS BU2, --KS_Short$.“Project SUBTYPE”, Team$.“Supervisor”, ecs.REQUEST_TYPE_ABBR, ecs.VPMO_PROJ_ID, ecs.REQUEST_ID, ecs.VPMO_PROJ_NAME, ecs.ASSIGNED_TO_NAME, COUNT(ecs.VPMO_PROJ_ID) AS CountOfVPMO_PROJ_ID, ecs.TCO_START_DT, working_days(er.request_date,SYSDATE)/10 AS of_SLO, working_days(er.request_date,SYSDATE) AS TCO_Duration, case when (working_days(er.request_date,SYSDATE))<=10 then ‘Met’ else ‘Not Met’ end As WorkdaySLA, TO_CHAR(er.request_date, ‘YYYY’) as Year, TO_CHAR(er.request_date, ‘mm’) as Month, TO_CHAR(ecs.tco_completed_dt, ‘iw’)+1 as Week, KS_Short$.“Main Priority”, KS_Short$.“Client Priority”, er.REQUEST_DATE, ecs.TCO_COMPLETED_DT, ers.REQ_STATUS_ID, erl.REQ_STATUS_DESC, --qry_ASAP_ALL_ROLE.CURRENT_STEP, case when “(A,D,C,R) - Status” = ‘A’ then ‘Active’ when “(A,D,C,R) - Status” = ‘D’ then ‘Done’ when “(A,D,C,R) - Status” = ‘C’ then ‘Cancelled’ when “(A,D,C,R) - Status” = ‘H’ then ‘Hold’ when “(A,D,C,R) - Status” = ‘R’ then ‘Refer’ else null end as VPMO_STATUS, ecs.NOTES FROM cscape1.eng_cat_stat_2@test ecs, cscape1.eng_request@test er, cscape1.eng_req_list@test erl, cscape1.eng_req_status@test ers, KS_Short$@excel, Team$@excel where ecs.request_id = er.request_id and (ecs.cat_name = erl.cat_name and ecs.request_id = erl.request_id) and ecs.assigned_to_CUID = Team$.attuid and erl.req_status_desc = ers.req_status_desc and lower(ecs.ASSIGNED_TO_CUID) = lower(Team$.“ATTUID”) and ecs.cat_name = ‘TSA’ and ecs.vpmo_proj_type = ‘B’ and er.request_date >= ‘01-JUN-2009’ group by Team$.“Supervisor”, ecs.REQUEST_TYPE_ABBR, ecs.VPMO_PROJ_ID, ecs.REQUEST_ID, ecs.VPMO_PROJ_NAME, ecs.ASSIGNED_TO_NAME, ecs.TCO_START_DT, working_days(er.request_date,SYSDATE), TO_CHAR(er.request_date, ‘YYYY’), TO_CHAR(er.request_date, ‘mm’), TO_CHAR(ecs.tco_completed_dt, ‘iw’)+1, KS_Short$.“Main Priority”, KS_Short$.“Client Priority”, er.REQUEST_DATE, ecs.TCO_COMPLETED_DT, ers.REQ_STATUS_ID, erl.REQ_STATUS_DESC, ecs.notes, case when “(A,D,C,R) - Status” = ‘A’ then ‘Active’ when “(A,D,C,R) - Status” = ‘D’ then ‘Done’ when “(A,D,C,R) - Status” = ‘C’ then ‘Cancelled’ when “(A,D,C,R) - Status” = ‘H’ then ‘Hold’ when “(A,D,C,R) - Status” = ‘R’ then ‘Refer’ else null end
ORA-00911: invalid character
Invalid SQL statement. Verify that you have selected the right schema. Only one SQL statement can be optimized in this window. To analyze PL/SQL code or multiple SQL statements use the SQL Scanner.
Getting Error running SQL Optimizer but will run in the editor