Hi Anaswer to your question IS declare cursor C1 is select

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 / ramprasad.s

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

Answer Posted / ramprasad.s

Hi Anaswer to your question
IS

declare
cursor C1 is select ENAME,SAL,COMM from EMP;
begin
For i IN C1 loop
IF i.comm > 299 AND i.comm < 999 then
dbms_output.put_line(i.ENAME || ' ' || '** Good
commission');
ELSIF i.comm >999 then
dbms_output.put_line(i.ENAME || ' ' || '** Very Good
commission');
ELSE
dbms_output.put_line(i.ENAME || ' ' || NVL(COMM,0));
END IF;
END LOOP;
END;

sun_ramprasad@yahoo.com

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is string data type in sql?

1045

What is the best sql course?

928

How can triggers be used for the table auditing?

1008

Can you join views in sql?

896

how is exception handling handled in mysql? : Sql dba

1006

What is pl sql in dbms?

899

what is a tablespace? : Sql dba

1004

How do you select unique values in sql?

932

How do I run pl sql in sql developer?

1056

What is primary key secondary key alternate key candidate key?

977

Explain constraints in sql?

978

Are sql connections encrypted?

952

how many sql dml commands are supported by 'mysql'? : Sql dba

1049

Define the select into statement.

991

what is text? : Sql dba

1006