updnval.sf.sql

OReilly Oracle PL SQL Programming第4版源代码

CREATE OR REPLACE FUNCTION updnval (
   col        IN   VARCHAR2
 , val        IN   NUMBER
 , start_in   IN   DATE
 , end_in     IN   DATE
)
   RETURN PLS_INTEGER
IS
BEGIN
   EXECUTE IMMEDIATE    'UPDATE employee SET '
                     || col
                     || ' = :the_value 
        WHERE hire_date BETWEEN :lo AND :hi'
               USING val, start_in, end_in;

   RETURN SQL%ROWCOUNT;
END;
/