How to cut text from the end of a CLOB column?
I need to cut the ,for example, the last 2000 charcters from the end of a CLOB column which stores sql queries.
In the end of each query , there is a remark that I need to parse.
Thanks in advance,
I think DBMS_LOB.copy would do the trick... if you have to fine tune it other DBMS_LOB functions might help as well.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Finally , I found a solution with regexp_replace function.
Click Here to Expand Forum to Full Width