How to cut text from the end of a CLOB column?

[nir_s]

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

[PAVB]

I think DBMS_LOB.copy would do the trick... if you have to fine tune it other DBMS_LOB functions might help as well.

[nir_s]

Thanks!
Finally , I found a solution with regexp_replace function.

Regards,
Nir