DECLARE CURSOR C1 IS SELECT empno,ename, sal, comm FROM emp; BE

Dear All,

Question for this Week

Find out possible error(s) (either at compile
time or at runtime) in the following PL/SQL block. State
the reason(s) and correct the errors.

Declare

Cursor C1 is select ename, sal, comm from emp;

Begin

For i in C1 Loop

If i.comm between 299 and 999 then

Dbms_output.put_line(i.Ename || ‘
** Good Commission’);

Elsif i.comm > 999 then

Dbms_output.put_line(i.Empno || ‘
** Very Good Commission’);

close C1;

Else

Dbms_output.put_line(i.Ename || ‘
** ’ ||nvl(i.comm,‘O’));

End if;

End Loop;

End;

Question Posted / tanmay agrawal

7 Answers
13131 Views
Accenture, I also Faced
E-Mail Answers

Answer Posted / tanmay agrawal

DECLARE
CURSOR C1
IS
SELECT empno,ename, sal, comm FROM emp;
BEGIN
FOR i IN C1
LOOP
IF i.comm BETWEEN 299 AND 999 THEN
Dbms_output.put_line(i.Ename || ' ** Good Commission');
elsif i.comm > 999 THEN
Dbms_output.put_line(i.Empno || ' ** Very Good Commission');
-- CLOSE C1;
ELSE
Dbms_output.put_line(i.Ename || ' ** ' ||NVL(to_char(i.comm),'O'));
END IF;
END LOOP;
END;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why we use sql profiler?

1023

Why do we need cursor in pl sql?

1187

Can we insert delete data in view?

996

Describe different types of general function used in sql?

1092

What is crud diagram?

993

Can we rollback truncate?

1049

Why do we need pl sql?

1037

Are null values same as that of zero or a blank space?

1065

How many primary keys can a table have?

1057

What is the difference between the conventional and direct path loader? : aql loader

1193

what is a foreign key ? : Sql dba

1114

Differentiate between % rowtype and type record.

1389

what does the t-sql command ident_incr does? : Transact sql

1125

What is mutating error?

1006

Is microsoft sql free?

1141