Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1)a) Create a procedure raise_amount to adjust the salaries. This procedure will take in the employee ID and the raise amount (expressed as a percentage,
1)a) Create a procedure raise_amount to adjust the salaries. This procedure will take in the employee ID and the raise amount (expressed as a percentage, such as .06). Based on the raise amount, the salary value in the EMPLOYEES table will be updated to the new salary. Execute the procedure to see the changes in salary column.
b) Create a stored procedure to insert a new record into DEPARTMENTS table with the given department number and name.
Department Number: 300
Department Name: Computer Science
oracie SGL Developer : lable CRACLE-MIN.EMPLOYEESSOCHALORACLE Eile Edit Yiew Nevigate Eun Team Iocls Window Help Wiekcome Page Columns Data IModel IConstraints IGrants IStatstics Triggers IFlashback IDependendies Details Partitions Indexes Isqu EMPLOYEES 1 EMPLOYEE_ID NUMBER ,0) l (null) 2 (nuil) 3 (nuii) 4(null) FIRSI NAME VARCHAR2 (20 BYTE) Yea na1l) (naii) LAST NAME VARCHAR2 (25 BITE) No VARCHAR2 (25 BYTE) No EMAIL 5 PHONE MUMBER VARCHAR2 (30 BYTE) Yea 6 BIRE DAIE 7 JOB ID 8 SALARY 9 CONMISSION PCT UMEER (20,2) 10 MANNGER ID NUMBER (6,0) 11 DEPARTMENT_ID NUMBER(4,0) na1l) (naii) 6 (nuii) (null) 8 (null) 9 (nail) 10 (null) 11 (null) VARCHAR2 (10 BYTE) No UMEER(,2) na1l) (naii) na1l) Messages-Log Messages Statements 000S 01/12/2018 3 orade SQL Developer : lable CRACLE-MIN.EMPLOYEESSOCHALORACLE Eile Edit yiew Navigate Bun Team locs yndow Help Wiekcome Page Columns Data Model lConstraints Grants Statistics Triggers IFlashback IDependendes Details Partitions Indexes Isqu JOB D Abel EABEL 011.44.1644.429267 11-HAY-96 SA REP TAYLOR 011.44.164.129265 24-MAR-98 SA REP KERANT 011.44.1644.429263 24-MAY-99 SA REP na1l 200 Jennifer alen 205 Sheiley 1ggina SHIGGIN 515.123.8080 iotkey EZLOTHEY 011.44.1344-429018 29-AN-00 SA MAN Messages -Log Messages Statements 01/12/2018 3Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started