To print only the file name

[madan agarwal]

Hi all,

when we write a query to know backup of database from system table it gives us the full path,i.e

d:\new\dump\adb a_databasename_ tiemstamp.bkp

But i want only the filename as output i.e "adba_databasen ame_tiemstamp.b kp"
is there any string function to it.

[ck9663]

1. Reverse the string.

2. Get the position of the first "\".

3. Do a substring from the first position of the reversed string to the position of the first "\"..

Happy coding!

-- CK

[madan agarwal]

Thanks for your help......