Answered step by step
Verified Expert Solution
Question
1 Approved Answer
IBIBCbank aims to automate banking transactions after the demonetization. They consulted IT sector to implement PLSQL block which performs deposit and withdraw operation. Mr .
IBIBCbank aims to automate banking transactions after the demonetization. They consulted IT sector to implement PLSQL block which performs deposit and withdraw operation. MrSam created an Oracle PLSQL procedure that performs money deposits. He wants to create a withdrawal procedure in oracle plsql Help him by writing the procedure which performs withdrawal for the given relation table. The procedure is taking two arguments: first argument is the account number, second argument is the amount to be withdrawn. The minimum balance to be maintained is Update the Account table, after transaction and create an entry in Transaction table, after each successful transaction. In Transaction table, TransactionType is "withdrawal" for withdrawal operation. Account AccNo BranchName, BalanceAmount Transaction AccNo TransactionDate, TransactionType, AmountWithdrawn BalanceAmount
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started