select d.file_name file_name, ............ from dba_data_files d, ....
This SQL returns outputs that are consistent in length,
+PRD_DG1/prd/datafile/t_s_m001.449.1073658715
+PRD_DG1/CPRD/C51A75014BC5438DE053317F2C0AC065/DATAFILE/t_s_m001.1428.1077374481
so that I need to grab up to the first slash from right.
The output I want to have is:
t_s_m001.449.1073658715
t_s_m001.1428.1077374481
Please let me know how to grab up to the first slash from right.
Thank you!