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 / intejar ahmad
invalid single quotes and cursor does not selecy empno
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why query optimization is needed?
Can you have more than one trigger on a table?
What is a database event trigger?
Explain clause in sql?
What is cursor status?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is an exception in PL/SQL? What are the two types of exceptions?
how many values can the set function of mysql take? : Sql dba
How long will it take to learn pl sql?
Is left join inner or outer by default?
How do I remove all records from a table?
What are the types of dbms?
Is sql port 1433 encrypted?
Does sql support programming?
What is a database trigger?