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
- 12893 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / ramprasad.s
Hi Anaswer to your question
IS
declare
cursor C1 is select ENAME,SAL,COMM from EMP;
begin
For i IN C1 loop
IF i.comm > 299 AND i.comm < 999 then
dbms_output.put_line(i.ENAME || ' ' || '** Good
commission');
ELSIF i.comm >999 then
dbms_output.put_line(i.ENAME || ' ' || '** Very Good
commission');
ELSE
dbms_output.put_line(i.ENAME || ' ' || NVL(COMM,0));
END IF;
END LOOP;
END;
sun_ramprasad@yahoo.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a system versioned table?
What is a stored procedure in sql with example?
How to load data with sql*loader?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
what is primary key? : Sql dba
what is a field in a database ? : Sql dba
How to convert comma separated string to array in pl/sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
How do I view tables in sql developer?
What is the least restrictive isolation level? : Transact sql
How to run sql commands in sql*plus?
What is auto increment?
How do I find duplicates in a single column in sql?
How do I delete a trigger?
What does desc stand for?
