invalid single quotes and cursor does not selecy empno

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 / intejar ahmad

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

Answer Posted / intejar ahmad

invalid single quotes and cursor does not selecy empno

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is row_number () in sql?

978

What is sap sql anywhere?

1068

Is t sql a programming language?

1063

Is left join and outer join same?

1054

what is denormalization. : Sql dba

1104

What is java sql driver?

1112

How to run sql*plus commands in sql developer?

1150

What is sqlservr exe?

973

Why are sql stored procedures used?

1052

What is aggregate function in sql?

1031

what is the difference between group by and order by in sql? : Sql dba

1123

What is a natural join sql?

965

Why do we use view in sql?

948

What is materialized view in sql?

916

Is natural join and inner join same?

920