SQL & PL/SQL

I've a CSV file, stored in my database as a CLOB. I've a plsql cartridge that reads the clob and displays the data to the user as a html table. I'm using string functions, instr and substr to extract the data from the csv file.

My CSV file is basically a converted version of an Excel spreadsheet uploaded by the user. It will always have a standardized format, with same number of columns. The first 10 rows will always be header information and data will be from row 12 onwards. Row 11 is empty.

I'm trying to find a way to count the number of rows in the CSV file (clob) so that every time I read the data, I can ignore everything before row#12.

I'm hitting a wall with what the approach should be.

Any help appreciated.