本文介绍了SQL错误:缺少关键字?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在这里遇到了关键字丢失的错误.我最近添加了WHERE子句,那时缺少关键字错误出现了.
I'm getting a missing keyword error here. I recently added the WHERE clause and that's when the missing keyword error came up.
Select job_id, (Case :P1_DATE_CHOOSER WHEN 'Daily' THEN trunc(start_time) WHEN 'Weekly' THEN trunc(start_time, 'WW') WHEN 'Monthly' THEN trunc(start_time, 'MM') END) "START_DATE", 1440*(END_TIME - START_TIME) "RUN_TIME" from NI_INFA_ACTIVITY_LOG_V WHERE (Case :P1_JOB_SIZE_CHOOSER WHEN 'Small' THEN (1440*(END_TIME - START_TIME)) <= 5 WHEN 'Medium' THEN (1440*(END_TIME - START_TIME)) > 5 AND (1440*(END_TIME - START_TIME)) <= 20 WHEN 'Large' THEN (1440*(END_TIME - START_TIME)) > 20 Else (1440*(END_TIME - START_TIME)) > 0 END)任何帮助将不胜感激.
推荐答案以这种方式执行:
.... .... WHERE :P1_JOB_SIZE_CHOOSER = 'Small' AND (1440*(END_TIME - START_TIME)) <= 5 OR :P1_JOB_SIZE_CHOOSER = 'Medium' AND (1440*(END_TIME - START_TIME)) > 5 AND (1440*(END_TIME - START_TIME)) <= 20 OR :P1_JOB_SIZE_CHOOSER = 'Large' AND ((1440*(END_TIME - START_TIME)) > 20 OR :P1_JOB_SIZE_CHOOSER NOT IN('Small','Medium','Large') AND (1440*(END_TIME - START_TIME)) > 0更多推荐
SQL错误:缺少关键字?
发布评论