Hi Tom,

I have 2 tables:
a)
Table BIGTEXT
2 columns:
ID NUMBER
TEXT CLOB

CREATE TABLE bigtext(id NUMBER, text CLOB);
INSERT INTO bigtext VALUES(1, 'This is a really long text that needs to be broken down into chunks of various sizes');

TEXT could also be VARCHAR2(4000).

b)
Table BROKENDOWN
4columns:
HOWMANY NUMBER
WORD1 VARCHAR2(200)
WORD2 VARCHAR2(200)
WORD3 VARCHAR2(200)

CREATE TABLE brokendown
(
howmany NUMBER,
word1 VARCHAR2(200),
word2 VARCHAR2(200),
word3 VARCHAR2(200)
);

Supposing table BIGTEXT only contains 1 row with ID = 1 and
TEXT = 'This is a really long text that needs to be broken down into chunks of various sizes'
I need to write a generic procedure that receives a parameter called HOWMANY, that does the following:

If HOWMANY = 1, it should perform INSERTs of the kind below:

INSERT INTO brokendown VALUES(1,'This',NULL,NULL);
INSERT INTO brokendown VALUES(1,'is',NULL,NULL);
INSERT INTO brokendown VALUES(1,'a',NULL,NULL);
INSERT INTO brokendown VALUES(1,'really',NULL,NULL);
INSERT INTO brokendown VALUES(1,'long',NULL,NULL);
..

If HOWMANY = 2:

INSERT INTO brokendown VALUES(2,'This','is',NULL);
INSERT INTO brokendown VALUES(2,'is','a',NULL);
INSERT INTO brokendown VALUES(2,'a','really',NULL);
INSERT INTO brokendown VALUES(2,'really','long',NULL);
INSERT INTO brokendown VALUES(2,'long','text',NULL);
..

If HOWMANY = 3:

INSERT INTO brokendown VALUES(3,'This','is','a');
INSERT INTO brokendown VALUES(3,'is','a','really');
INSERT INTO brokendown VALUES(3,'a','really','long');
INSERT INTO brokendown VALUES(3,'really','long','text');
INSERT INTO brokendown VALUES(3,'long','text','that');
..

I would appreciate a hint on how to best approach the problem and find a well-performing solution that consumes the least amount of resources.
Thanks,
-Dan