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
12897 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

What is sqlcommand?

1024

What is a behavioral trigger?

970

how to calculate expressions with sql statements? : Sql dba

1032

What is delete command in sql?

1108

What is pl sql variable?

979

What is sql profiling in oracle?

1056

How can I speed up sql query?

958

What does pl sql developer do?

922

What is the usage of when clause in trigger?

1051

What is normalisation and its types?

997

Can we use ddl statements in stored procedure sql server?

1006

What is the non-clustered index in sql?

1056

what is primary key? : Sql dba

1023

What is the difference between pl and sql?

1089

What is an ndf file?

987