UpdateEmployeeName

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   EMPLOYEES   >   UpdateEmployeeName

Procedure body UpdateEmployeeName(employeeId INTERGER,fname NVARCHAR2,lname NVARCHAR2), Package EMPLOYEES

Name	Datatype	Precision	Description
employeeId	interger		INTERGER, parameter of EMPLOYEES.UpdateEmployeeName
fname	nvarchar2		NVARCHAR2, parameter of EMPLOYEES.UpdateEmployeeName
lname	nvarchar2		NVARCHAR2, parameter of EMPLOYEES.UpdateEmployeeName

procedure UpdateEmployeeName(employeeId in interger, fname in nvarchar2, lname in nvarchar2)
    is
    begin
        UPDATE EMPLOYEE
			SET emp_fname=fname, emp_lname=lname
			WHERE emp_Id = employeeId;

    end UpdateEmployeeName

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
<DEFAULT SCHEMA>.EMPLOYEES.UpdateEmployeeName	Procedure	Procedure interface UpdateEmployeeName(employeeId INTERGER,fname NVARCHAR2,lname NVARCHAR2), Package EMPLOYEES
<DEFAULT SCHEMA>.EMPLOYEE.EMP_FNAME	Column	Column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_LNAME	Column	Column
NVARCHAR2	PL/SQL System type	PL/SQL System Object
INTERGER	Undefined Item
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column