-
sql functions to trim absolute path to display just filename
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 '/%/'
siva prakash
DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|