1 Reply Latest reply: Feb 6, 2013 1:49 PM by Denes Kubicek RSS

    Show APEX Row Number in Report Region

    989555
      I would like to display the row number in the report region at the beginning of each row for each page (based on the number of rows to display per page).
      So if the number of rows per page is 15, I would want to show each row from 1 to 15. When going to the next page (16 - 31) I would like to show row 1 to 15 again next to each row.
      And if the number of rows per page is 20, I want to see row numbers 1 to 20 on each page.

      Since I believe an Update button only processes the current page, I would like to then use this row numbers (1 - 15) to get the values of the displayed column for each row to perform an insert to another table.
        • 1. Re: Show APEX Row Number in Report Region
          Denes Kubicek
          You can use something like this:
          SELECT apex_item.text (1, '#ROWNUM#') row_num, empno, ename,
                 deptno, comm, sal, mgr
            FROM emp
          Example is here:

          http://apex.oracle.com/pls/apex/f?p=31517:284

          Denes Kubicek
          -------------------------------------------------------------------
          http://deneskubicek.blogspot.com/
          http://www.apress.com/9781430235125
          http://apex.oracle.com/pls/apex/f?p=31517:1
          http://www.amazon.de/Oracle-APEX-XE-Praxis/dp/3826655494
          -------------------------------------------------------------------