Why not ORA-00938: not enough arguments for function with this SQL??
SQL> SELECT empno,deptno
2 FROM scott.emp
3 WHERE deptno IN (DECODE(deptno,'10','20','30','30'),'40','50')
4 /
EMPNO DEPTNO
---------- ----------
7499 30
7521 30
7654 30
7698 30
7844 30
7900 30
6 rows selected.
SQL> DESC vw_ins_outstanding
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
REC_TYPE VARCHAR2(7)
ASSORTED_CODE VARCHAR2(12)
CLAIM_CODE VARCHAR2(10)
CLAIM_INFO_CODE VARCHAR2(10)
CLASS_CODE VARCHAR2(2)
PRINCIPAL_COMPANY VARCHAR2(1)
INSURANCE_TYPE_CODE VARCHAR2(1)
DUE_AMOUNT NUMBER
DUE_DATE DATE
MODE_CODE VARCHAR2(3)
SEQ_NO NUMBER(28)
COINSURANCE_CODE VARCHAR2(8)
POLICY_CODE VARCHAR2(12)
CHEQUE_NO VARCHAR2(20)
CHEQUE_AMOUNT NUMBER
CHEQUE_DATE DATE
VOUCHER_NO VARCHAR2(15)
VOUCHER_DATE DATE
SUP_BY VARCHAR2(20)
PAID_TO_CODE VARCHAR2(8)
CANCEL_DATE DATE
SUP_DATE DATE
Why ORA-00938: not enough arguments for function with this SQL??
SQL> SELECT mode_code
2 FROM vw_ins_outstanding
3 WHERE MODE_CODE IN (DECODE(PRINCIPAL_COMPANY,'D','24','34'),'31','02')
4 /
WHERE MODE_CODE IN (DECODE(PRINCIPAL_COMPANY,'D','24','34'),'31','02')
*
ERROR at line 3:
ORA-00938: not enough arguments for function
Khurram