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

From: Daniel Fink <daniel.fink_at_sun.com>
Date: Wed, 23 Jul 2003 07:40:31 -0600
Message-Id: <25998.339115@fatcity.com>

This is a multi-part message in MIME format.

--------------5794C0540B58E4271D685BB3
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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 :'/oracle/d0/data/user.dbf' --> user.dbf
> Maybe using translate function ?
> Thank in advance !
> Philippe

--------------5794C0540B58E4271D685BB3
Content-Type: text/x-vcard; charset=us-ascii;  name="daniel.fink.vcf"

Content-Transfer-Encoding: 7bit
Content-Description: Card for Daniel Fink
Content-Disposition: attachment;

 filename="daniel.fink.vcf"

begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:daniel.fink_at_sun.com
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard

--------------5794C0540B58E4271D685BB3-- Received on Wed Jul 23 2003 - 08:40:31 CDT