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

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 / umadevi

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

Answer Posted / umadevi

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');
Else
Dbms_output.put_line(i.Ename || '**
' || ( i.comm||','||'O'));
End if;
End Loop;
End;
/

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is dml statement?

999

What is clustered index in sql?

1098

what is union? : Sql dba

1081

In what condition is it good to disable a trigger?

1069

Explain how exception handling is done in advance pl/sql?

1045

Why use subqueries instead of joins?

1134

What is rename command in sql?

1093

how to use like conditions? : Sql dba

1164

What is cascade in sql?

1015

Can we use having without group by in sql?

1048

Is stored procedure faster than query?

1019

How to fix oracle error ora-00942: table or view does not exist

1083

What is not null in sql?

1107

What are all ddl commands?

1127

Inline the values in PL/SQL, what does it mean.?

1274