Every Row into an individual Columns in SQL Query

VARIABLE	dj	REFCURSOR

CREATE OR REPLACE FUNCTION 	     dept_by_job
RETURN  SYS_REFCURSOR
IS
	-- dept_by_job returns a SYS_REFCURSOR that has
	-- one row for every department in scott.emp and one
	-- column for every job, showing the number of employees
	-- in that department with that job.

	return_csr	SYS_REFCURSOR;
	select_txt	VARCHAR2 (5000);
BEGIN
	-- 1st part of query is fixed
	select_txt := 'SELECT	  deptno ';

	-- 2nd part of query depends on what's in the table
	FOR  r  IN ( SELECT DISTINCT  job 
	     	     FROM   	      scott.emp 
		     ORDER BY 	      job
		   )
	LOOP
		select_txt := select_txt || ', COUNT (CASE WHEN job = '''
			      		 || r.job
					 || '''	THEN 1 END)	AS '
					 || r.job
					 || '_cnt ';
	END LOOP;

	-- Last part of query is fixed
	select_txt := select_txt || ' FROM	  scott.emp'
		      		 || ' GROUP BY	  deptno'
				 || ' ORDER BY	  deptno';

	OPEN  return_csr
	FOR   select_txt;

	RETURN  return_csr;
END	dept_by_job
;
/
SHOW ERRORS

EXEC  :dj := dept_by_job;

PRINT :dj

CREATE OR REPLACE FUNCTION 	     pivot_rv
RETURN  SYS_REFCURSOR
IS
	return_csr	SYS_REFCURSOR;
	select_txt	VARCHAR2 (5000);
BEGIN
	-- 1st part of query is fixed
	select_txt := 'SELECT	  ';

	-- 2nd part of query depends on what's in the table
	FOR  r  IN ( SELECT DISTINCT  field_name
	     	     ,	    	      ROW_NUMBER () OVER (ORDER BY id)	AS rnum
	     	     FROM   	      render_values
		     ORDER BY 	      rnum
		   )
	LOOP
		select_txt := select_txt || CASE
						 WHEN  r.rnum > 1
						 THEN  ','
			      		    END
			      		 || 'MAX (CASE WHEN field_name = '''
			      		 || r.field_name
					 || '''	THEN field_value END)	AS "'
					 || r.field_name
					 || '"';
	END LOOP;

	-- Last part of query is fixed
	select_txt := select_txt || ' FROM	 render_values';

	OPEN  return_csr
	FOR   select_txt;

	RETURN  return_csr;
END	pivot_rv
;