Write a PL/SQL program for a function returning total tax collected from a particular place.
PL/SQL program Create of Replace Function Tax-Amt
Place varchar2,
Return Number is
Place_wise_tot_tax : = 0;
Begin
Select sum(TaxAmt) from Tax where location = Place;
Place_wise_tot_tax = TaxAmt;
Return Place_wise_tot_tax
End Tax-Amt