Thursday, November 13, 2008

USING BIND VARIABLE IN PL/SQL

DECLARE
bonus NUMBER(8,2);
emp_id NUMBER(6) := 100;
BEGIN
EXECUTE IMMEDIATE 'DELETE FROM EMP WHERE employee_id = :emp_id' USING emp_id;
END;
/

No comments:

search engine

Custom Search