script to insert multiple line breaks in clob oracle
I have a table with a clob column and some of the records need to have line breaks inserted. Due to the large number of records involved, doing so manually would take too long. Is there a way to insert multiple line breaks into each clob field?
When I say multiple line breaks I don't mean multiple line breaks all together; I mean multiple line breaks spread out among the content of the clob field
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!