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