StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POORA-00905: missing keyword error in case after where clause
text
Body
copied!<p>I have the following query which is giving error <code>ORA-00905: missing keyword</code>. I've not been able to find the syntax despite continuous efforts for last few hours. Please help. </p> <pre><code>SELECT a.DOCUMENT_CATEGORY, a.template_id, a.category_id, a.REVIEW_CATEGORY, a.WITH_BIDS, a.WITH_FINAL_DOCUMENTS, b.divn_id, b.deptt_id, a.vdr_id, C.DEPARTMENT, a.TEMPLATE_TITLE FROM DCTM_VDR_REF_DTLS a, DCTM_VDR_REF_MASTER b, VW_DIVN_DIR c WHERE b.DIVN_ID = c.DIVN_CODE AND b.DEPTT_ID = c.SECTN_CODE AND a.vdr_id = b.vdr_id AND (b.REFERENCE_NUMBER, b.APPROVED_ON) IN ( SELECT MAX (REFERENCE_NUMBER), MAX (APPROVED_ON) FROM DCTM_VDR_REF_MASTER WHERE REFERENCE_NUMBER = (SELECT DISTINCT NVL (TRIM (MR_NUMBER), TRIM (TENDER_NO)) FROM EILEDMS.EIL_DOCUMENT_SV@EDMS_DBLINK WHERE object_name = 'A307-0IC-JA-MR-7960-1030-157-FOA' AND r_object_type = 'eil_foa_order_pr_doc' AND ( title = 'FOA' OR title = 'DRAFT FOA')) AND APPROVED_ON IS NOT NULL GROUP BY DIVN_ID, DEPTT_ID) AND REVIEW_CATEGORY <> 'Delete Category' AND (CASE (SELECT IS_SCHEDULE_LOCKED FROM DCTM_VENDOR_SCHEDULE WHERE SCH_ID = 359) WHEN 0 THEN 1 WHEN 1 THEN (a.template_id || '-' || a.category_id) IN (SELECT template_id || '-' || category_id FROM DCTM_VENDOR_SCH_UNLOCK_DTLS WHERE APPROVAL = 'Y' AND APPROVAL_UPTO >= SYSDATE AND CONSUMED = 0 AND sch_ID = 359) END) = 1 ORDER BY c.DEPARTMENT ASC, a.TEMPLATE_ID, a.SORT_ORDER, a.DOCUMENT_CATEGORY ASC </code></pre> <p><strong>Can't we use IN clause inside a THEN statement?</strong></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload