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

Which one is faster ienumerable or iqueryable?

930

What is fmtonly in sql?

1079

How do you copy a table in sql?

1066

Can we have two clustered index on a table?

1021

Is sql similar to python?

969

What are the sql commands?

1171

What is sql dialect?

1112

What is sqlerrm?

929

Is sql between inclusive?

1121

What is record type in pl sql?

984

Which query operators in sql is used for pattern matching?

959

What is benefit of creating memory optimized table?

970

What is composite primary key in sql?

995

Is the primary key an index?

1024

Can a key be both primary and foreign?

991