Re: SQL question

But of course -- just use a negative one as the position to the instr function.

>From the SQL manual:

INSTR searches string for substring.

     position is an integer indicating the character of string where Oracle
     begins the search. If position is negative, Oracle counts and searches
     backward from the end of string.

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560

P: 919.466.7337
F: 919.466.7427
E: Diana_Duncan_at_ttpartners.com


                                                                                       
                              
                    Glenn Travis                                                       
                              
                    <c-glenn.travis        To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>       
                    @wcom.com>             cc:                                         
                              
                    Sent by:               Fax to:                                     
                              
                    root_at_fatcity.co        Subject:     SQL question                   
                              
                    m                                                                  
                              
                                                                                       
                              
                                                                                       
                              
                    05/01/2001                                                         
                              
                    04:36 PM                                                           
                              
                    Please respond                                                     
                              
                    to ORACLE-L                                                        
                              
                                                                                       
                              
                                                                                       
                              

How would you take the same string "/dir1/dir2/test/file.out", and return "file.out". Assume you do not know where the last '/' is or how many there are. What I need is a reverse instr function. Find the last occurrance of '/', not the first.

Can it be done in sqlplus???

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Diana_Duncan_at_ttpartners.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).