Home » Other » Client Tools » DEFINE in TOAD vs SQLPLUS
DEFINE in TOAD vs SQLPLUS [message #18059] |
Tue, 08 February 2005 13:32  |
rishank
Messages: 3 Registered: February 2005
|
Junior Member |
|
|
hi
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.
|
|
|
|
|
|
Goto Forum:
Current Time: Tue Feb 25 21:11:19 CST 2025
|