Menu
If no slashes were found, return the original string It will work with both Windows and UNIX system file paths. The following function called get_filename will extract the directory path. I want to retrieve the following: 'example.xls'Īnswer: You can create a custom function in Oracle that will retrieve the filename from the string value. How can I extract the filename (including the suffix) from the string in Oracle?įor example, if I have a full file path as follows: 'c:\windows\temp\example.xls' Question: I have a string that contains the full path to a file. Oracle / PLSQL: Extract the filename (including suffix) from a full file path
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |