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?
DECLARE
TYPE trec IS RECORD
svsal number
svminsal number default
svhiredate hremployees.hiredatetype,
cvrecemp rowtype;
cvmyrec trec;
BEGIN
cvmyrec.svsal : cvmyrec.svminsal ;
cvmyrec : sysdate;
IF svsal THEN
SELECT INTO cvmyrec.cvrecemp FROM hremployees WHERE employeeid ;
DBMSOUTPUT.PUTLINE cvrecemp.lastname tocharcvmyrec.svhiredate tocharcvmyrec.svsal;
END IF;
END;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
