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;
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 left join in postgresql?
How can I see all tables in sql?
Is pl sql better than sql?
What is the process of copying data from table a to table b?
How do I run a program in pl sql?
Is a table valued function object?
What is difference between stored procedures and application procedures?
Why is pl sql used?
what are properties of a transaction? : Sql dba
What are database links used for?
What is sql lookup?
Why sql query is slow?
How do you create an update query?
What is a constraint? Tell me about its various levels.
What are pl sql procedures?