لمن لديه الخبره والمحاوله في حل التمارين التاليه

[أحساس غالي]

1.

a. Create a PL/SQL function named getsmallest that will accept three numbers as parameters. It will then determine and return the smallest number.

====================

Write a PL/SQL block with CURSOR declarations. Read all the records from Employee table and save the same records to New_Emp table.

=====================

List and write the syntax of the three iterative constructs. Give one example for each.

==================



a. Create a table EvenNum with the following structure:

EvenNum(Enum Number(3))
b. Insert all even numbers from 2 to 20 into the above created table. Commit before the end of the block.