-
What is the use of Parametric Cursor ?
dinesh.smhdr
- Sep 13th, 2011
"oracle8 declare cursor c_emp (cin_No NUMBER) is select count(*) from employee where id = cin_No; v_deptNo employee.id%type:=10; v_countEmp NUMBER; begi...
-
When would you use stored procedure or functions ?
Explain the scenario of the best usage
krishna
- Dec 17th, 2015
When there is return value then we use function else we use procedure and for DMLs also
ptmich
- May 28th, 2012
It is best to go for a function when a value needs to be computed but a stored procedure is useful when you need to execute business logic.
