I have one table emp ,
CREATE TABLE EMP
(ID NUMBER,
DES CLOB);

Actualy data in table
id desc
1 I have pen in India
2 My name is pravin

create function using loop when data length size more than 6 then other data is next row in oracle.

output
id desc
1 I have
1 pen i
1 n India
2 My nam
2 e is p
2 ravin

converting clob to varchar