DeleteEmployeeById

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   EMPLOYEES   >   DeleteEmployeeById

Procedure body DeleteEmployeeById(id NUMBER), Package EMPLOYEES

Name	Datatype	Precision	Description
id	NUMBER		NUMBER, parameter of EMPLOYEES.DeleteEmployeeById

procedure DeleteEmployeeById(id in NUMBER )
    Is 

    Begin
		DELETE EMPLOYEE where emp_id = id;
		COMMIT;

    end DeleteEmployeeById

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
<DEFAULT SCHEMA>.EMPLOYEES.DeleteEmployeeById	Procedure	Procedure interface DeleteEmployeeById(id NUMBER), Package EMPLOYEES
NUMBER	PL/SQL System type	PL/SQL System Object
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column

Name	Types	Description
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer	Procedure	Procedure body ProductsByCustomer(Customer_Id NUMBER), Package PRODUCTS
<DEFAULT SCHEMA>.DATA.sp_deleteemployee	Procedure	Procedure body sp_deleteemployee(employeeId NUMBER), Package DATA