Please use Pl/sql ro answer the following question, and red had been provide First create below table, INSERT INTO this table by building PL/SQL BEGIN END block First create this table CREATE TABLE selected_emp (emp_id number(5), salary number(9,2), level varchar2(10) )
dont try to copy existing sol
I have existing solution
If copied solutiion wiil surely downvote
Please use Pl/sql ro answer the following question, and red had been provide
First create below table, INSERT INTO this table by building PL/SQL BEGIN END block
- First create this table
CREATE TABLE selected_emp
(emp_id number(5),
salary number(9,2),
level varchar2(10)
)
- Create a cursor to pull entire employee tables into it
Cursor cur_emp IS
SELECT employee_id, firstname, salary FROM employees;
- In BEGIN and END block
Create Cursor FOR LOOP to fetch each record one by one.
Each time new record fetch
Make IF THEN ELSE block and check salary and make INSERT INTO accordingly
If salary is in between 1 to 4000 THEN class is D
INSERT INTO selected_emp VALUES (q.employee_id, q.salary, ‘D’);
If salary is in between 4001 to 7000 THEN class is C
INSERT INTO selected_emp VALUES (q.employee_id, q.salary, ‘C’);
If salary is in between 7001 to 10000 THEN class B
INSERT INTO selected_emp VALUES (q.employee_id, q.salary, ‘B’);
everything ELSE THEN Class A
INSERT INTO selected_emp VALUES (q.employee_id, q.salary, ‘A);
END IF;
END LOOP;
END;
Step by step
Solved in 2 steps
