View from CLOB chunks

From: <yuri.dench_at_gmail.com>
Date: Fri, 14 Nov 2008 10:55:48 -0800 (PST)
Message-ID: <8a22f11a-c250-4dd4-adff-9d9e7145d157@e1g2000pra.googlegroups.com>

Hello,
Is it possible to creare a view that will split single CLOB column into multiple chunks of VARCHAR2 something like this:

TABLE:

---

ID INTEGER
DATA CLOB into VIEW:

---

ID INTEGER
CHUNK_ID INTEGER
DATA VARCHAR(1000 char)

Thanks, Yuri Received on Fri Nov 14 2008 - 12:55:48 CST