Please do the PL$/$SQL code this feature and put it inside a table also as a reference take my feature $2$ just like how i did it$.$

$($Feature $2$: add a company. Input includes a company name. The procedure does the following:

$1)$ It first checks whether there is a company with the same name as the input, if so prints a message 'company already exists' and stops.

$2)$ If the company does not exist, it inserts a row into the company table with a newly generated company ID $($using sequence$)$ and the input company name. It also prints out the new vehicle ID$.$ Delete this before turning in$)$

$--$ Drop existing table and cascade constraints

DROP TABLE company CASCADE CONSTRAINTS;

SET SERVEROUTPUT ON;

$--$ Create sequence for company IDs

CREATE SEQUENCE companySeq START WITH $1$;

$--$ Create company table

CREATE TABLE company$($

compID INT NOT NULL,

compName VARCHAR$(100)$ NOT NULL,

PRIMARY KEY $($compID$)$

$)$;

$--$ Create or replace the procedure for adding companies$--$

CREATE OR REPLACE PROCEDURE addCompany$($

newcompName VARCHAR$2$

$)$ AS

v$\_$comp$\_$id NUMBER;

BEGIN

BEGIN

SELECT compID INTO v$\_$comp$\_$id FROM company WHERE compName $=$ newcompName;

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Company already exists.$\text{'})$;

EXCEPTION

WHEN NO$\_$DATA$\_$FOUND THEN

SELECT companySeq.NEXTVAL INTO v$\_$comp$\_$id FROM DUAL;

INSERT INTO company $($compID$,$ compName$)$

VALUES $($v$\_$comp$\_$id$,$ newcompName$)$;

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$New company ID: $\text{'}||$ v$\_$comp$\_$id$)$;

END;

END;

$--$Regular Cases$--$

BEGIN

addCompany$(\text{'}$Google$\text{'})$;

addCompany$(\text{'}$Amazon$\text{'})$;

addCompany$(\text{'}$Meta$\text{'})$;

END;

$--$Select to verify entries$--$

SELECT $*$ FROM company;

$--$Special Cases$--$

BEGIN

addCompany$(\text{'}$Google$\text{'})$;

addCompany$(\text{'}$Amazon$\text{'})$;

END;

$--$Verfiy companies were not added$--$

SELECT $*$ FROM company;

$($Feature $3$: search for job posts. The input includes a keyword, job type $($full time or part time$),$ and a state. The procedure does the following:

$1)$ It finds all job posts that are active and the job title or job description has a substring that matches the input keyword, and the job post's state and job type match the input state and job type. The procedure prints out the matching job posts' job post id$,$ associated company name, job title, description, min and max pay, city and state.

$2)$ In case there are no matching job posts, print out $\text{'}$No job posts found'.

Hint: to match a substring in the procedure, use

where column$\_$name like $\text{'}\%\text{'}||$ input$\_$keyword $||\text{'}\%\text{'}$