Sunday, February 7, 2016

insert emp

CREATE OR REPLACE PROCEDURE insert_employee (EMPLOYEE_ID IN number, NAME IN VARCHAR2, ADDRESS IN VARCHAR2 ) IS
BEGIN   
    INSERT INTO EMP_T (EMP_ID, NAME, ADDRESS)
    VALUES (EMPLOYEE_ID, NAME, ADDRESS);
END;

No comments:

Post a Comment

Installation of Oracle 11g and 12c *Kindly see the You Tube video to get installed the database.