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.
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;
Latest Post: Create a PL/SQL Trigger to display the message "Re-Order Level reached for the item-item name" Our newest member: dhkdjsd Recent Posts Unread Posts
