I have the following query :

DECLARE
tmp INTEGER;

BEGIN
tmp := 1;
DBMS_OUTPUT.PUT _LINE(tmp);
INSERT INTO WT_PTFMGT
(SESSION_ID,TYP E,L, R, C,GBL_INSTRUMEN T_ID,COM,L_HOLD ING, R_HOLDING, C_HOLDING)
SELECT
tmp,
'BO' TYPE,
DECODE(L_INSTRU MENT_ID,NULL,'N ','Y') L,
DECODE(R_INSTRU MENT_ID,NULL,'N ','Y') R,...