ORA-00905：缺少关键字 [英] ORA-00905: missing keyword

问题描述

，CASE XLE.LEGAL_ENTITY_IDENTIFIER

当'AUXITRSA'然后'FR-Esterline Auxitrol'

当'CMCELECT'那么'CA-Esterline'

当'DARCHOLD'那么'英国 - Esterline Darchem'

当'EAVCTLFR'那么'FR-Esterline ESL航空电子'时

当'ADVSNMEX'那么'MX- SMX'

当'EBELGIUM'那么'Esterline BE-97777'

当'EIDSHANG'那么'CN-SHA'

WHEN 'ESMEXICO'然后'MX-EMX'

当'ETINDLTD'那么'在'EIN'时

当'ETCORPFR'那么'FR-Esterline法国管理'时>
当'GAMLTDUK'那么'英国 - Esterline Gamesman'

当'GAMESHEN'然后'CN-GCH'

当'LTJTVENT'那么'CN- LTA'

当'LREMEDIC'那么'DE-Esterli ne LRE Medical'

当'LIASIAPA'然后'HK-LIA'

当'LIEEURSA'那么

情况下LOC.INTERNAL_LOCATION_CODE =' FR-RRB-1'那么'FR-Esterline Leach INT Sarralbe'

当LOC.INTERNAL_LOCATION_CODE ='FR-NIT-1'然后'FR-Esterline Leach International NIORT'

结束

什么时候'LIGERMAN'THEN'DE-Esterline Leach International'

当'LIMEXICO'然后'MX-LMX'

WHEN 'LIEUTDKG'THEN'UK-Esterline Leach International'

当'RACALLTD'那么'英国Esterline Racal ACOUSTICS'

当'SODOMREP'那么'做SDR'时

什么时候'SOGERMAN'THEN'DE-Esterline Souriau'

当'SOINDIA1''那''in-SIN'

当'SOMORROC'那么' MA-ESTERLINE

当'SOUKLTD1'那么'英国 - Esterline Souriau'

当'SUNMEXIC'那么'MX-SBM'

当'TECNOCON'那么'FR-Esterline Technocontact SAS'

当'WESTONAE'那么'英国 - Esterline Weston Aerospace'

当'SOURISAS'那么'FR-Esterline Souriau SAS'
WHEN'KTAUKLTD'THEN'GB-Esterline TA Mfg Limited'

当PPL.PERSON_NUMBER ='541'那么'FR-Esterline French Management'-当我添加这个我的时候将错误视为缺少关键字

ELSE'US-Esterline'

END SUBUNIT

,CASE XLE.LEGAL_ENTITY_IDENTIFIER
WHEN 'AUXITRSA' THEN 'FR-Esterline Auxitrol'
WHEN 'CMCELECT' THEN 'CA-Esterline'
WHEN 'DARCHOLD' THEN 'UK-Esterline Darchem'
WHEN 'EAVCTLFR' THEN 'FR-Esterline ESL Avionics'
WHEN 'ADVSNMEX' THEN 'MX-SMX'
WHEN 'EBELGIUM' THEN 'BE-Esterline BE-97777'
WHEN 'EIDSHANG' THEN 'CN-SHA'
WHEN 'ESMEXICO' THEN 'MX-EMX'
WHEN 'ETINDLTD' THEN 'IN-EIN'
WHEN 'ETCORPFR' THEN 'FR-Esterline French Management'
WHEN 'GAMLTDUK' THEN 'UK-Esterline Gamesman'
WHEN 'GAMESHEN' THEN 'CN-GCH'
WHEN 'LTJTVENT' THEN 'CN-LTA'
WHEN 'LREMEDIC' THEN 'DE-Esterline LRE Medical'
WHEN 'LIASIAPA' THEN 'HK-LIA'
WHEN 'LIEEURSA' THEN
CASE WHEN LOC.INTERNAL_LOCATION_CODE ='FR-RRB-1' THEN 'FR-Esterline Leach INT Sarralbe'
WHEN LOC.INTERNAL_LOCATION_CODE ='FR-NIT-1' THEN 'FR-Esterline Leach International NIORT'
END
WHEN 'LIGERMAN' THEN 'DE-Esterline Leach International'
WHEN 'LIMEXICO' THEN 'MX-LMX'
WHEN 'LIEUTDKG' THEN 'UK-Esterline Leach International'
WHEN 'RACALLTD' THEN 'UK-Esterline Racal ACOUSTICS'
WHEN 'SODOMREP' THEN 'DO-SDR'
WHEN 'SOGERMAN' THEN 'DE-Esterline Souriau'
WHEN 'SOINDIA1' THEN 'IN-SIN'
WHEN 'SOMORROC' THEN 'MA-Esterline'
WHEN 'SOUKLTD1' THEN 'UK-Esterline Souriau'
WHEN 'SUNMEXIC' THEN 'MX-SBM'
WHEN 'TECNOCON' THEN 'FR-Esterline Technocontact SAS'
WHEN 'WESTONAE' THEN 'UK-Esterline Weston Aerospace'
WHEN 'SOURISAS' THEN 'FR-Esterline Souriau SAS'
WHEN 'KTAUKLTD' THEN 'GB-Esterline TA Mfg Limited'
WHEN PPL.PERSON_NUMBER = '541' THEN 'FR-Esterline French Management'- when i was adding this i am getting the error as missing keyword
ELSE 'US-Esterline'
END SUBUNIT

推荐答案

您正在混音CASE的2语法！

You are mixing the 2 syntax of CASE !

WHEN 'KTAUKLTD' THEN 'GB-Esterline TA Mfg Limited'
WHEN PPL.PERSON_NUMBER = '541' THEN 'FR-Esterline French Management'- when i was adding this i am getting the error as missing keyword
ELSE 'US-Esterline'

首先WHEN os 1语法，第二个是另一个。



CASE（Transact-SQL） [ ^ ]

这篇关于ORA-00905：缺少关键字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！