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
- 12632 Views
- Accenture, I also Faced
- E-Mail Answers
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
Write an sql query to select all records from the table?
What is native sql query?
Why we use cross join?
how many sql ddl commands are supported by 'mysql'? : Sql dba
Mention what does plv msg allows you to do?
explain normalization concept? : Sql dba
Does oracle use sql?
What is snowflake sql?
What does stand for in sql?
What is a scalar value in sql?
What type of join is sql join?
Why do we create stored procedures & functions in pl/sql and how are they different?
Can a foreign key be a duplicate?
What is data manipulation language?
What is a sql schema used for?
