My Work
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
search engine
Custom Search
No comments:
Post a Comment