What is column?
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 many rows will return from dual table?
What is scope and visibility in PL/SQL?
Why coalesce is used in sql?
What is the use of <> sql?
How would you pass hints to the sql processor?
What are the rules to be applied to nulls whilst doing comparisons?
What does count (*) mean?
What is sql and explain its components?
How many triggers can be applied to a table?
Explain the difference between drop and truncate commands in sql?
How to run sql commands in sql*plus?