AS
BEGIN
UPDATE employees SET p_column_name = p_new_data
WHERE emp_num = p_emp_num;
END;
/
In your above statement the p_column_name is to be replaced by the actual coloumn name of the table.
prashant
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.