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

Hire Writer

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

Related Posts

Tiffany from New York Essays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/MdQVRT