PLEASE make the code usable in ORACLE/SQL DEVELOPER
/* 1. Write a script that creates and calls a stored procedurenamed insert_category.
First, code a statement that creates a procedure that adds a newrow to the Categories table.
To do that, this procedure should have one parameter for thecategory name.
Code at least two CALL statements that test this procedure. (Notethat this table doesn’t allow duplicate category names.) */
/* 2. Write a script that creates and calls a stored function nameddiscount_price that calculates the discount price
of an item in the Order_Items table (discount amount subtractedfrom item price). To do that, this function should accept
one parameter
OR
OR