Please see the attached sql function question requiring an sql function to be written to calculate a mortgage APR. Below is an example of my function call, where I am calculating the monthly payment for a mortgage with a principal amount of $250,000, an APR of 4.125%, and a loan duration of 30 years:

In SQL Server, specify the differences between the two character data types as follows: NVARCHAR VARCHAR

Create a PL/SQL database programming block with DECLARE BEGIN   END; In Declare section define a local scalar (simple) variables. lv_deptno  NUMBER And assign initial values as 10 lv_deptno  NUMBER := 50; In Declare section again, define a cursor and select last_name, salary and manager_id of employees the ones who are working in the department defined in a) In this example department will be lv_deptno:=50;   Sample code:   Cursor c_emp as   SELECT last_name, salary, manager_id FROM employees   WHERE department_id =    lv_deptno;   In the execution section (BEGIN and END) Create CURSOR FOR LOOP for cursor to process In this cursor loop, your code has to check salary and also manager_id  numbers each time new records being fetched. And based on these conditions either employee gets raise or not get raise. If employee salary is less than 5000 and also if employees managers is either 101 or 124 then it means employee is due for raise otherwise employee is not due for raise   Sample…

Write a function and a call program in PL/SQL to sum the even integers between 1 and any number that is passed as parameter to the function. Use the editor to format your answer