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 / tanmay agrawal
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');
-- CLOSE C1;
ELSE
Dbms_output.put_line(i.Ename || ' ** ' ||NVL(to_char(i.comm),'O'));
END IF;
END LOOP;
END;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to rename an existing column in a table? : Sql dba
Can a select statement fire a trigger?
What are sql indexes?
What is a database event trigger?
How does cross join work?
Where do we use pl sql?
What is sap sql anywhere?
What is a null value?
Which is better join or subquery?
What are the different tcl commands in sql?
What is clause?
What makes a good primary key?
What is sql in java?
What are inner and outer joins examples of both?
How can I make sql query run faster?