please using oracle sql!!! thanks

using movie_fact table

1.by invoking a PL/SQL stored procedure with an OUT parameter. The PL/SQL procedure is to use a cursor that scans through all rows in the fact table, keeping a running total and count for (non-null) ratings, and then returning the average.

2. by a loop in Java, processing a ResultSet obtained after issuing a "select rating from movie fact" (without a where clause).

Using System.nanoTime(), your program should print out the number of milliseconds between the time you started and nished computing the average rating, for each of the two different ways.