SQL question : How to retrieve the File_name without Directorie P

2003-07-23 Thread NGUYEN Philippe (Cetelem)
Title: SQL question : How to retrieve the File_name without Directorie Path ? Hi Gurus! a very simple problem for You :I just want to retrieve the .dbf name from file_name column in dba_data_files. eg :'/oracle/d0/data/user.dbf' -- user.dbf Maybe using translate function ? Thank in advance !

Re: SQL question : How to retrieve the File_name without Directorie P

2003-07-23 Thread Daniel Fink
Phillipe, Look at using INSTR and SUBSTR to calculate the position of the last / and work from there. Daniel NGUYEN Philippe (Cetelem) wrote: Hi Gurus! a very simple problem for You :I just want to retrieve the .dbf name from file_name column in dba_data_files. eg