|
DeleteCustomerById
|
|
Procedure body DeleteCustomerById(customer_Id NUMBER), Package CUSTOMERS
Name
|
Datatype
|
Precision
|
Description
|
customer_Id
|
NUMBER
|
|
NUMBER, parameter of CUSTOMERS.DeleteCustomerById
|
procedure DeleteCustomerById( customer_Id in NUMBER )
is
begin
CheckCustomer(customer_Id);
DELETE CUSTOMER where ID = id;
COMMIT;
end DeleteCustomerById
Name
|
Types
|
Description
|
CUSTOMER
|
Table
|
Table
|
<DEFAULT SCHEMA>.CUSTOMERS.DeleteCustomerById
|
Procedure
|
Procedure interface DeleteCustomerById(customer_Id NUMBER), Package CUSTOMERS
|
<DEFAULT SCHEMA>.CUSTOMERS.CheckCustomer
|
Function
|
Function body CheckCustomer(customer_Id NUMBER) return CheckCustomer, Package CUSTOMERS
|
NUMBER
|
PL/SQL System type
|
PL/SQL System Object
|
ID
|
Undefined Item
|
|