The TeradataForum depends on cookies for its operation. Please refer to our Privacy page for details. By closing this banner or continuing to browse the TeradataForum website, you agree to the use of cookies.

 
Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 15 Dec 2008 @ 13:36:38 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Regarding index function
 
From:   Sridhar Nakka

Hi,

We can use index or position function in teradata to get the position of searching string. But in oracle we can get the second occurrence of the searching string by specifying the parameters like

     SELECT INSTR('Take the first four characters', 'a','1','2') FOUND_1
     FROM dual;

will give 2nd a position that is 23.

As of I see index is useful to get the first occurrence only. So how we can achieve above result by using index or position function in teradata?



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 31 Dec 2015