SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg : remove Newlines in CLOB -

915396Feb 18 2013 — edited Feb 18 2013

Hi Experts,

I've a CLOB column where the data length is huge. So just posting below a small snapshot.

--Load files               :
--Create directory				:
--***************************************************



--
-- name  : raddo
-- location    : cad
-- id     : free
--

INSERT INTO fff.roller (roll_id,
                                     roll_name,
                                     roll_description,

I need to remove multiple newlines and if possible want to bring all code ( which are not commented ) into a single row...

Expected o/p :

--Load files               :
--Create directory				:
--***************************************************
--
-- name  : raddo
-- location    : cad
-- id     : free
--
INSERT INTO fff.roller (roll_id,roll_name,roll_description,

Please let me know if this is feasible... and any suggestions is highly appreciated.

Thanks
Ranit B.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2013

Added on Feb 18 2013

12 comments

1,942 views