I wrote a stored procedure to select all records from a table. Since I'm new to Oracle I have few questions.
- Is this Correct?
- Is this the best way to select all records from a table?
- How can I view result in SP in DB level?
alter PROCEDURE employee_getall
(
cv_results in out sys_refcursor
)
IS
BEGIN
open cv_results for
select *
from employee_master
EXCEPTION
WHEN OTHERS THEN
NULL ;
END;