CREATE VIEW example_view AS
  SELECT v.id_vlak AS id_vlak, v.druh.nazov_druhu AS nazov_druhu FROM vlak v;

SELECT * FROM example_view;

CREATE OR REPLACE FUNCTION sys_refcursor_view_example RETURN sys_refcursor
IS
  vysledok sys_refcursor;
BEGIN
  OPEN vysledok FOR SELECT * FROM example_view;
                      RETURN vysledok;
END;
/