How do you retrive the file name from the folder Name from Folder path:
flname := 'C:\Folder1\SubFolder1\SubFolder3\MyTest.xls';
SELECT substr(flname, instr(flname, '\', -1) + 1) FROM dual;flname := 'C:\Folder1\SubFolder1\SubFolder3\MyTest.xls';
Output will be
MyTest.xls
No comments:
Post a Comment