Archives of the TeradataForum
Message Posted: Mon, 15 Dec 2008 @ 13:36:38 GMT
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?
|Copyright 2012 - All Rights Reserved|
|Last Modified: 04 Nov 2013|