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,...

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

1. First create this table

CREATE TABLE selected_emp

(emp_id   number(5),

 salary   number(9,2),

 level    varchar2(10)

 )

1. Create a cursor to pull entire employee tables into it

Cursor  cur_emp IS

SELECT employee_id, firstname, salary FROM employees;

1. 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;