Question

Consider a table EMPLOYEE (empno , ename , salary) Write a PL/SQL code block that will accept customer number from the user and deduct a balance by Rs. 2000 from inputted customer no account in the bank only if the customer has a minimum balance of Rs. 1000 after amount is deducted, otherwise display message “NOT ENOUGH BALANCE”.

Answer 1

Explanation:

table EMPLOYEE (empno , ename , salary) Write a PL/SQL code block that will accept customer number from the user and deduct a balance by Rs. 2000 from inputted customer no account in the bank only if the customer has a minimum balance of Rs. 1000 after amount is deducted, otherwise display message “NOT ENOUGH BALANCE”.