What is the difference between functions, procedures, and packages in pl/sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is online transaction processing (oltp)?
What is primary key and foreign key with example?
What is pl/sql tables?
What is the maximum size of sqlite database?
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 difference between cluster and non-cluster index?
what is recursive stored procedure? : Sql dba
How do I copy a table in sql?
How to display the contents of a current record fetched in a reference cursor?
what does myisamchk do? : Sql dba
Write a query to display the current date in sql?
What is java sql drivermanager?