Doc

Name: BLOCK_ROWS.sql

Author: Mahnho Han

The number of rows per block

#

SELECT substr(t.rowid,1,8) || '-' || substr(t.rowid,15,4) BLOCK,

count(*) ROW_NUM

FROM &table_name t

WHERE rownum < 2000

GROUP BY substr(t,rowid,1,8) || '-' || substr(t.rowid,15,4)

/