What is pl/sql table? Why it is used?
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;
What is the use of index in hive?
What does the argument [or replace] do?
What is the difference between truncate and drop statements?
what is global variable in package
What is trigger in sql? Explain
How do you update f as m and m as f from the below table testtable?
How does cross join work?
Whate is use of MOD function in pl/sql.
Is drop table faster than truncate?
How will we see framework of a table?
What are different types of sql commands?