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.

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

Regards,
Nir