SCOTT@orcl12c> CREATE TABLE tablea
  2    (anid	NUMBER,
  3  	aname	VARCHAR2(15),
  4  	atotal	NUMBER)
  5  /

Table created.

SCOTT@orcl12c> INSERT ALL
  2  INTO tablea VALUES (57, 'Agatha',	 28)
  3  INTO tablea VALUES (58, 'Bertie',	 13)
  4  INTO tablea VALUES (59, 'Guilford', 56)
  5  INTO tablea VALUES (60, 'Francois', 80)
  6  SELECT * FROM DUAL
  7  /

4 rows created.

SCOTT@orcl12c> SELECT * FROM tablea ORDER BY anid
  2  /

      ANID ANAME               ATOTAL
---------- --------------- ----------
        57 Agatha                  28
        58 Bertie                  13
        59 Guilford                56
        60 Francois                80

4 rows selected.

SCOTT@orcl12c> SELECT anid "AnID", aname "Aname", atotal "Total",
  2  	    'a' || COLUMN_VALUE "Noofrows"
  3  FROM   tablea,
  4  	    TABLE
  5  	      (CAST
  6  		 (MULTISET
  7  		    (SELECT LEVEL
  8  		     FROM   DUAL
  9  		     CONNECT BY LEVEL <= CEIL (atotal / 14))
 10  		  AS SYS.ODCINUMBERLIST))
 11  ORDER  BY anid, "Noofrows"
 12  /

      AnID Aname                Total Noofrows
---------- --------------- ---------- -----------------------------------------
        57 Agatha                  28 a1
        57 Agatha                  28 a2
        58 Bertie                  13 a1
        59 Guilford                56 a1
        59 Guilford                56 a2
        59 Guilford                56 a3
        59 Guilford                56 a4
        60 Francois                80 a1
        60 Francois                80 a2
        60 Francois                80 a3
        60 Francois                80 a4
        60 Francois                80 a5
        60 Francois                80 a6

13 rows selected.