: Multiple recipients of list ORACLE-L
Asunto: PL/SQL stment
Hi lists
the flwng
DECLARE
V_sal emp.sal%type;
BEGIN
SELECT sal
INTO v_sal
FROM emp
WHERE empno=p_empno;
IF v_sal2000 then
UPDATE emp
SET sal=sal*1.2
WHERE empno=p_empno;
END IF;
END;
When I run the above, the first time the is asking
Hi
Make define p_empno in the header of script and undefine in the end then
it's work's !
Regards
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, September 16, 2001 7:15 AM
Hi lists
the flwng
DECLARE
V_sal emp.sal%type;
BEGIN
Hi lists
the flwng
DECLARE
V_sal emp.sal%type;
BEGIN
SELECT sal
INTO v_sal
FROM emp
WHERE empno=p_empno;
IF v_sal2000 then
UPDATE emp
SET sal=sal*1.2
WHERE empno=p_empno;
END IF;
END;
When I run the above, the first time the is asking the empno. But the
next time I run it is taking the same