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
- 11470 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / umadevi
Declare
Cursor C1 is select empno, 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');
Else
Dbms_output.put_line(i.Ename || '**
' || ( i.comm||','||'O'));
End if;
End Loop;
End;
/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are pl sql procedures?
Why we use pl sql?
What is cold data?
What is Difference Between Unique and Primary Key Constraints?
What is PL/SQL Records?
What is a sql statement?
Can we call dml statement in function?
What are the different types of constraints?
Why do we use set serveroutput on?
What is use of term?
Could you please provide oca (oracle 10g) dumps for my certification ?
Does oracle use sql?
what is single byte over head in oracle..?
Explain the rollback statement?
What schema means?
