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
- 11449 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 subsets of sql?
Can we use delete in merge statement?
What is the use of double ampersand (&&) in sql queries? Give an example
What is difference between db2 and sql?
How many postgresql users are there, worldwide?
What is a constraint?
How to add new employee details in an employee_details table with the following details
What is a relationship and what are they?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is auto increment feature in sql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is rank dense_rank and partition in sql?
What do you mean by stored procedures? How do we use it?
How exception is different from error?
