Question d’entretien chez Capgemini
Write PLSQL code block to return multiple of records from table using function
Réponse à la question d'entretien
Utilisateur anonyme
4 mars 2025
I Answered this Question by write sample code and explain the how it works and why to use. CREATE OR REPLACE FUNCTION get_employees RETURN Ref Cursor AS Declare RetCur Ref Cursor; BEGIN OPEN RetCur FOR SELECT employee_id, employee_name, salary FROM employees; RETURN RetCur ; END get_employees;