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)
-
create or replace PROCEDURE xx_upload_po_attachment(errbuff out varchar2, retcode out number) IS CURSOR cur_new_attmt IS select ponumbe...
-
I encountered this issue while Jdeveloper Setup. Below are the steps followed. Step 1: Run regedit (remember to run it as the administrato... -
SELECT parent_flex_value, flex_value, ROWNUM AS row_num FROM apps.fnd_flex_value_ch...
No comments:
Post a Comment