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
- 13126 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 is the difference between blob and text? : Sql dba
Explain the working of primary key?
What is trigger and stored procedure in sql?
How to add new employee details in an employee_details table with the following details
what are the different tables present in mysql? : Sql dba
What is cross join sql?
What is sql table?
What are different types of sql commands?
What is difference between group by and partition by?
Can we insert data into view?
Why is nosql good?
what happens if null values are involved in expressions? : Sql dba
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
how to use case expression? : Sql dba
What is oracle pl sql developer?
