Write a PL/SQL code block that will accept an account number from the user & debit an amount of Rs2000 from the account if the account has a min balance of Rs500 after the amount is debited. The process is to be fired on the account table. Table name :- Accounts Account Id Name Bal AC001 John 5000

AC002 Smith 10000 AC003 Mita 5000 AC004 Melba 15000 AC005 Sunita 10000 [Hint: Choose AC003 , /* Accept an account no from the user*/ accnt_no:=:accnt_no;]

Write a PL/SQL code block that will accept an account number from the user & debit an amount of Rs2000 from the account if the account has a min balance of Rs500 after the amount is debited. The process is to be fired on the account table. Table name :- Accounts [ F [Hint: Choose AC003 ,/* Accept an account no from the user*/ accnt_no:=:accnt_no;]