Create an API and 4 functions in PLSQL using SQL Devellopper

Job ID: 32730588

Budget: $30 – $250 CAD

Approximatively 3 hours of work. 40 CAD
You will have to read a document specifying the job to de done.
It consist of using an already given Database and create 4 stocked functions to make use of the database and to create the API that goes along with them.
The fuctions should use multiple tables.
The choice of the the functions is free between 5 requested.
Create at least one package to keep the variables you use in the different functions.
Test functions with anonymous blocks
Code should be commented
The functions should use different aspects (cursors , collections, mass treatment ,…)

FRENCH talker prefered