Question: I know I can use `CASE` statement inside `VALUES` part of an insert statement but I am a bit confused.

I have a statement like,

Answer: 
You can try also a procedure:

```
create or replace procedure insert_XYZ (P_ED_MSISDN         IN VARCHAR2,
                                        P_ED_OTHER_PARTY    IN VARCHAR2) is

begin  

    INSERT INTO TABLE_XYZ ( ED_MSISDN, 
                            ED_OTHER_PARTY,  
                            ED_DURATION) 
      VALUES (P_ED_MSISDN , 
              P_ED_OTHER_PARTY , 
              CASE  
                  WHEN P_ED_OTHER_PARTY = '6598898745' THEN 
                      '9999999' 
                  ELSE
                      '88888' 
              END);

END;

```
Here's a query structure that you can use (using JohnnyBeGoody's suggestion of using a SELECT statement to select the values).

```
INSERT INTO TABLE_XYZ (ED_MSISDN, ED_OTHER_PARTY,  ED_DURATION) 
SELECT 
    '2054896545' ED_MSISDN, 
    '6598898745' ED_OTHER_PARTY, 
    CASE  
        WHEN ED_OTHER_PARTY = '6598898745' THEN '9999999' 
        ELSE '88888' 
    END ED_DURATION
FROM DUAL;

```