Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12930 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
What is forward declaration in pl sql?
How exception handling is done in advance pl/sql?
what is not null constraint? : Sql dba
Show the two pl/sql cursor exceptions.
What is rank dense_rank and partition in sql?
How do I start sql from command line?
How do I partition a table in sql?
Differentiate between % rowtype and type record.
Can we use delete in merge statement?
Explain the difference between drop and truncate commands in sql?
What can sql server reporting services do?
What is loop in pl sql?
What version is sql?
Can we use join in subquery?
If a cursor is open, how can we find in a pl/sql block?
