Common Content for Data Integration
- Common Content for Data Integration 10.5.4
- All Products
CREATE OR REPLACE FUNCTION fetchEMPinfo (p_State IN VARCHAR2 ) return types.cursortype AS my_cursor types.cursortype; BEGIN OPEN my_cursor FOR SELECT EMP_ID, NAME, CITY FROM EMP WHERE STATE = p_State ORDER BY EMP_ID; RETURN my_cursor; END;