-
How to cut text from the end of a CLOB column?
Hi guys,
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,
Nir
-
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.
-
Thanks!
Finally , I found a solution with regexp_replace function.
Regards,
Nir
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|