DEFINE in TOAD vs SQLPLUS
437978Feb 8 2005 — edited Feb 8 2005hi
my code looks like this
DEFINE p_ann_sal= 6000;
DECLARE
v_sal NUMBER (9,2) := &p_annual_sal;
BEGIN
v_sal := v_sal/12;
DBMS_OUTPUT.PUT_LINE (TO_CHAR(V_SAL));
END;
When I run it using sqlplus its working fine, asking for the input variable at runtime and works well
But I'm unable to enter the input value at runtime in TOAD. I'm using the SQL window of TOAD to run the code.
Thanks
rishank.