Question: Review below code.. Which lines have problem and explain why? 1 DECLARE 2 TYPE t _ rec IS RECORD 3 ( sv _ sal number

Review below code.. Which lines have problem and explain why?
1 DECLARE
2 TYPE t_rec IS RECORD
3(sv_sal number(8),
4 sv_minsal number(8) default 1000,
5 sv_hire_date hr_employees.hire_date%type,
6 cv_recemp %rowtype);
7 cv_myrec t_rec;
8 BEGIN
9 cv_myrec.sv_sal := cv_myrec.sv_minsal +500;
10 cv_myrec := sysdate;
11 IF sv_sal >1000 THEN
12 SELECT * INTO cv_myrec.cv_recemp FROM hr_employees WHERE employee_id =100;
13 DBMS_OUTPUT.PUT_LINE( cv_recemp.last_name ||''|| to_char(cv_myrec.sv_hire_date)||''|| to_char(cv_myrec.sv_sal));
14 END IF;
15 END;
 Review below code.. Which lines have problem and explain why? 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!