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
- 12898 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / radha sri seshu.kolla
WHEN YOU ARE USING CURSOR WIH FOR LOOP NO NEED TO SPECIFY
CLOSE CURSOR.
SINGLE CORES ARE LOOKING AS IF THEY ARE SINGLE CORES, BUT
THEY ARE SPECIAL CHARACTERS.
YOU ARE USIGN NVL FUNCTION IN THIS. YOU GAVE FIRST ARGUMENT
AS NUMBER DATATYPE, AND SECOND IS CHARACTER DATA TYPE. 0
AND O LOOK LIKE SAME JUST IT IS TO CONFUSE THE CANDIDATES.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the ways on commenting in a pl/sql code?
Is sql database free?
what is the difference difference between procedure and packages
Which certification is best for sql?
What are the different types of constraints?
How many databases can sql express handle?
what is a cursor? : Sql dba
How do you break a loop in pl sql?
Can a foreign key have a different name?
how to fetch common records from two tables? : Sql dba
Does inner join return duplicate rows?
How do I sort a table in sql?
Why triggers are used?
how to show all tables with 'mysql'? : Sql dba
How do I trace sql profiler?
