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
- 10403 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 maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What are the advantages of indexing?
How do I count rows in sql query?
What is left join in sql?
Explain the difference between rename and alias?
Does a primary key have to be a number?
What are different clauses used in sql?
How do I access sql anywhere database?
What is the advantage of index in sql?
What is dynamic sql in pl sql?
How do you create an update query?
How many types of index are there?
What is materialized view. What are different methods of refresh?
what are the types of join and explain each? : Sql dba
How global cursor can be declare with dynamic trigger ?
