SQL错误:缺少关键字?

本文介绍了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