Aug 09, 2020 6:03 am
Write a PL/SQL procedure to perform a withdrawal operation that only permits a withdrawal, if there are sufficient funds in the account then update the Account table and print the message, 'Transaction successful.' else print, 'Insufficient Amount'.
Please check the attachment for additional information.
2 Replies
Aug 09, 2020 6:22 am
You can try the below procedure.
Create or replace procedure
withdraw(acno number, amt number)
Is
V_amt number:=0;
Begin
Select Balance into v_amt
From account
Where accno = acno;
If amt < v_amt then
Update account
Set balance = balance -amt
Where accno = acno;
Commit;
dbms_output.put_line('Transaction Successful');
Else
dbms_output.put_line('Insufficient balance');
End if;
Exception
When others then
Rollback;
End;