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
12631 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 I sort a table in sql?

983

What are variables in pl sql?

1094

What is sequence in sql?

945

What is coalesce sql?

943

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3927

What are the query optimization techniques?

888

What is AUTH_ID and AUTH_USER in pl/sql ?

2142

How would you convert date into julian date format?

949

Can we rollback delete command?

935

Can we join tables without foreign key?

909

Is crud a cuss word?

975

What is sqlcontext?

990

How do I filter in sql profiler?

949

What are inner outer left and right joins in sql?

965

What is set serveroutput on?

1088