Can we debug stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
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;
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is pls integer?
What are the differences between implicit and explicit cursors?
How many row comparison operators are used while working with a subquery?
How is a process of pl/sql compiled?
Why do we create views in sql?
Is it possible to create the following trigger: before or after update trigger for each row?
What are the advantages of sql? Explain
What is the use of count (*) in sql?
What is a boolean in sql?
How do you delete a table?