ERPstuff - Oracle EBS Community

HI


I need to select all the records from a column that has exactly two 'A'. No matters where they appear in the atring.

Any predefined or new function can be used.

Kindly advice

Thanks

use instr() function

The "in string" functions search string for substring. The function returns an integer indicating the position of the character in string that is the first character of this occurrence.


<b>http://www.psoug.org/reference/substr_instr.html</b>

<b>http://download-west.oracle.com/docs/cd ... 55a.htm</b>