SQL> select filename from binfileobject ;

FILENAME
--------------------------------------------------------------------------------
/var/tmp/ClientPer26692.tmp
/var/tmp/ClientPer26693.tmp
/var/tmp/ClientPer50108.tmp
/var/tmp/xyz/ClientPer26694.tmp
/var/tmp/abcdef/ClientPer26691.tmp
/var/tmp/hgdfjhagd/ClientPer7363216104934551917.tmp

can you let us know sql function to display it as
~~~~~~~~~~~~~~~~~
ClientPer26692.tmp
ClientPer26693.tmp
ClientPer50108.tmp
ClientPer26694.tmp
ClientPer26691.tmp
ClientPer7363216104934551917.tmp

something like ltrim , replace '/%/'