What are conditional predicates?
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 to drop an existing table in mysql? : Sql dba
How to update salary of employees department wise?
How do I view tables in sql developer?
write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35
What is sp_helptext?
which will fire first ? Trigger or Constraint
24 Answers i2, IBM,
Is left join inner or outer by default?
how would concatenate strings in mysql? : Sql dba
how to calcuate the second highest salary of he employee
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
How to use boolean type in select statement?