create or replace PROCEDURE PRC_BALA(LV_rEF OUT SYS_REFCURSOR,LV_TABLE_NAME VARCHAR2,ROWS_FROM NUMBER,ROWS_TO NUMBER,COL_RANGE_FROM NUMBER,COL_RANGE_TO NUMBER)  IS
LV_QUERY VARCHAR2(9000);
COLUMN_NM VARCHAR2(2000) :=NULL;
ORG_COLUMN_NM  VARCHAR2(2000) :=NULL;
CURSOR C1 IS SELECT COLUMN_NAME,ROWNUM,ROWNO 
               FROM (
                     SELECT COLUMN_NAME,ROWNUM,ROW_NUMBER() OVER(ORDER BY COLUMN_NAME) ROWNO 
                       FROM USER_TAB_COLUMNS 
                      WHERE TABLE_NAME=UPPER(LV_TABLE_NAME) 
                   ORDER BY COLUMN_NAME ASC)
              WHERE ROWNO BETWEEN COL_RANGE_FROM AND COL_RANGE_TO;
BEGIN
  FOR I IN C1 LOOP
    COLUMN_NM :=COLUMN_NM||','||I.COLUMN_NAME ; 
  END LOOP;
  ORG_COLUMN_NM :=  SUBSTR(COLUMN_NM,2)||',';
  LV_QUERY := 'SELECT '||ORG_COLUMN_NM||' ROWNO FROM (
  SELECT '||ORG_COLUMN_NM||' ROW_NUMBER() OVER(ORDER BY ROWNUM) ROWNO  FROM '||LV_TABLE_NAME ||') WHERE ROWNO BETWEEN '||ROWS_FROM||' AND '||ROWS_TO; 
  OPEN LV_rEF FOR LV_QUERY;
END;

create or replace PROCEDURE PRC_BALA(LV_rEF OUT SYS_REFCURSOR,LV_TABLE_NAME VARCHAR2,COL_RANGE_FROM NUMBER,COL_RANGE_TO NUMBER)  IS
LV_QUERY VARCHAR2(9000);
COLUMN_NM VARCHAR2(2000) :=NULL;
ORG_COLUMN_NM  VARCHAR2(2000) :=NULL;
CURSOR C1 IS SELECT COLUMN_NAME,ROWNO 
               FROM (
                     SELECT COLUMN_NAME,ROW_NUMBER() OVER(ORDER BY COLUMN_NAME) ROWNO 
                       FROM USER_TAB_COLUMNS 
                      WHERE TABLE_NAME=UPPER(LV_TABLE_NAME) 
                   )
              WHERE ROWNO BETWEEN COL_RANGE_FROM AND COL_RANGE_TO;
BEGIN
  FOR I IN C1 LOOP
    COLUMN_NM :=COLUMN_NM||','||I.COLUMN_NAME ; 
  END LOOP;
  ORG_COLUMN_NM :=  SUBSTR(COLUMN_NM,2);
  LV_QUERY := 'SELECT '||ORG_COLUMN_NM||' FROM (
  SELECT '||ORG_COLUMN_NM||'  FROM '||LV_TABLE_NAME ||')'; 
  OPEN LV_rEF FOR LV_QUERY;
END;