How to find the number of occurences in a particular string.
SELECT length('simhachalam')-LENgth(REPLACE('simhachalam', 'm', '')) FROM dual;
Output: 2
SELECT length('simhachalam')-LENgth(REPLACE('simhachalam', 'a', '')) FROM dual;
Output:3
Subscribe to:
Post Comments (Atom)
-
Requirement: There is a lookup in fnd lookups table, business wants that lookup to be modified by them, adding lookup values, modifying and ...
-
Table to find out the fusion Instance name : Fusion.ASK_DEPLOYED_DOMAINS Query:- SELECT external_virtual_host , SUBSTR ( e...
-
I encountered this issue while Jdeveloper Setup. Below are the steps followed. Step 1: Run regedit (remember to run it as the administrato...
No comments:
Post a Comment