select

-- Use 1000-byte chunks instead of 100-byte chunks (only 10 rows)
SELECT
chunk_num,
start_byte,
end_byte,
blob_to_text_range(blob_column, start_byte, end_byte) as chunk_content
FROM (
SELECT
level as chunk_num,
(level * 1000 - 999) as start_byte, -- 1, 1001, 2001...
(level * 1000) as end_byte -- 1000, 2000, 3000...
FROM dual
CONNECT BY level <= CEIL(9600 / 1000) -- Only 10 chunks!
), your_table
WHERE your_table.id = 123
ORDER BY chunk_num;