display the last ten characters of a string 1

[ksnpc]

It seems like it shouldn't be too hard to do this, but I can't get it to work. I am trying to see the last part of a clob field. Does anyone have any suggestions on how to do this?

 

[SantaMufasa]

Sure, ksnpc, here is a proof of concept:

SQL> create table ksnpc (x clob);

Table created.

SQL> insert into ksnpc values ('123456789Last10chrs');

1 row created.

SQL> select substr(x,-10) from ksnpc;

SUBSTR(X,-10)
------------------------------------------------------
Last10chrs

Let us know if this resolves your question.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[ksnpc]

That took care of it, thanks. I was making it way too complicated.