The number of inches is to be eased to the stored function as a parameter. The stored function should return the truncated number of yards with the help of return statement. Calling program for the stored function need not be written. 3. Write a stored procedure by the name of Simi_inter to calculate the amount of interest on a bank account. The formulae are:lent = p*t*r/100 Mat=p + Inter where:lent is the total interest earned. P is the principal, t is the number of years the money is earning interest, and r is the rate of interest.
We will write a custom essay sample
on Sql Excersizes or any similar
topic specifically for you
Your stored procedure should accept the values of p, t and r as parameters and splay the Interest and Total amount on the screen. Display the results on the screen using db’s_output. Put_line. Calling program for the stored procedure need not be written. 4. Write a stored function by the name of Mum_cube. The stored function should return the cube of a number ‘N’. The number ‘N’ should be passed to the stored function as a parameter. Calling program for the stored function need not be written. 5. Write a stored procedure by the name of HRS_call. The Mono, Depend and Sal should be passed as parameters to your stored procedure.See More on Parameter