Write function

[shruti1210]

Create the table with the following details:
Table name--- Employee_XXXX
EMPID NUMBER(3),
ENAME VARCHAR2(15 BYTE),
HIREDATE DATE NOT NULL,
ORIG_SALARY NUMBER(6),
CURR_SALARY NUMBER(6),
JOBTITLE VARCHAR
Department
Project_name Char(4),
EMPID NUMBER(3),
REGION VARCHAR2(1 BYTE)
As the company is expanding people working under a given project are shifted from Chennai to Coimbatore. For these employees in ‘Chennai’ Region to ‘Coimbatore’.Further all the PA are given a promotion to Associate level with a increase in the salary by 1000 Rupees. Create a procedure with the Project name as the input and perform the necessary actions and updations.