DBMS_LOB.SUBSTR
Let suppose i have a table A having columns remarks but remarks column is clob data type
and i want to insert those data into Table B but table B have remarks1, remarks2 with varchar2(4000)
then how you insert data from table A to table B
INSERT INTO TBL_CLOB_DATA_INSERT (REMARK1, REMARK2)
SELECT
DBMS_LOB.SUBSTR(remarks, 4000) "FIRST_4000_CHAR",
DBMS_LOB.SUBSTR(remarks, 4000,4001) "NEXT_4000_CHAR",
-- DBMS_LOB.SUBSTR(remarks, 3,3) "REMANINIG THREE",
DBMS_LOB.getlength(remarks) clob_length
FROM CLOB_DEMO;
create table TBL_CLOB_DATA_INSERT (remark1 varchar2(4000),remark2 varchar2(4000))