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

How do rank () and dense_rank () differ?

1047

How to place comments in pl/sql?

1161

State some properties of relational databases?

1058

What is query optimization in sql?

987

What are some emotional triggers?

986

When can we use the where clause and the having clause?

1020

Define union, minus, union all, intersect ?

1010

What is relationship? How many types of relationship are there?

1185

Give the order of sql select?

1137

What program will open a mdb file?

969

How show all rows in sql?

1016

How do I find sql profiler?

945

What is sql resultset?

991

What is the life of an sql statement?

1024

What is trigger types in sql?

996