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;
- 7 Answers
- 11448 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / ganesh sawant from finacle
It will run and will give o/p
*******************************************
set serveroutput on
declare
Cursor C1 is select A_no, A_name from ABC;
Begin
For i in C1 Loop
If i.A_no between 10 and 20 then
Dbms_output.put_line(i.A_name || '** Good Commission******');
Elsif i.A_no > 2000 then
Dbms_output.put_line(i.A_name || '** Very Good Commission##########');
close C1;
Else
Dbms_output.put_line(i.A_name || '&&&&&& ' ||nvl(i.A_name,'O'));
End if;
End Loop;
End;
===========
PL/SQL procedure successfully completed.
RAJ** Good Commission******
RAJ** Good Commission******
RAJ** Good Commission******
RAJ** Good Commission******
BABA** Good Commission******
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to get @@error and @@rowcount at the same time? : Sql dba
What are joins in sql?
What is full join?
How to assign sql query results to pl sql variables?
What is memory optimized?
Can you join a table to itself?
What are commit, rollback, and savepoint?
How do I install sql?
What is recursive join in sql?
What is union?
What is a function in oracle pl sql?
Is sql considered coding?
How do I count duplicates in sql?
how many tables will create when we create table, what are they? : Sql dba
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
