I need helo on the following questions:

Part 1:

(1) What are the advantages of performing search strategies using PL / SQL versus just SQL code?

(2) What is the latest version of PL / SQL ?

(3) How does JAVA code integrate with PL / SQL ? A good reference that might help with this answer is:

Part 2 Data modeling

(1) Dissect the following code by putting comment statements for every line! ( Use the double hyphen to have the server ignore the comments. Refer to the example given for the variable num1 to get you started ) .

DECLARE

num1 data_table.n1%TYPE; -- declare the variable num1

num2 data_table.n2%TYPE; --

num3 data_table.n3%TYPE; --

result temp.col1%TYPE;

CURSOR c1 IS

SELECT n1, n2, n3 FROM data_table WHERE exper_num = 1;

BEGIN

OPEN c1;

LOOP

FETCH c1 INTO num1, num2, num3;

EXIT WHEN c1%NOTFOUND; -- TRUE when FETCH finds no more rows

result := num2/(num1 + num3);

INSERT INTO temp VALUES (result, NULL, NULL);

END LOOP;

CLOSE c1;

COMMIT;

END;

Part 3- Data Modeling

(1) Define and or contrast the following. Also, give examples! Give appropriate

references using the APA standard.

Packages

Procedures

Functions

vArrays

Nested Tables

Associative Tables

Part 4

(1)

Given two variables, x and y, create and execute a program that will

(i) ask for input from the user on the values for x and y

(ii) calculate the value of the following algebraic expression z = 5 x ² y ? 2 x y ² + 7 x / y ? x + 2 y ? 17

(iii) display the output of the above mathematical processes; and

(iv) test the program with x = 10 and with y = 5 , and then test the program with two different values of x and y

Some starter code is given below.

SET SERVEROUTPUT ON;

SET VERIFY OFF;

DECLARE

x number := &x_number;

y number

z number

BEGIN

z := 5 * x**2 * y + ;

dbms_output.put_line('The value of the polynomial is ');

dbms_output.put_line( when x = and y = || y );

EXCEPTION -- throw an exception when division by zero

END;