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
- 12903 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
Can a foreign key be a duplicate?
What is auto increment feature in sql?
What are the different ddl commands in sql?
What is input buffer in sql*plus?
explain primary keys and auto increment fields in mysql : sql dba
Why is sql better than hql?
What does partition by mean in sql?
How to display Row Number with Records in Oracle SQL Plus?
What are triggers and its types?
what is a foreign key ? : Sql dba
What is varray in pl sql?
What is dynamic query?
Which join condition can be specified using on clause?
What is difference between primary and secondary key?
Explain about various levels of constraint.
