Answer Posted / mahesh
select regexp_count('hello','l') from dual;
or
SELECT LENGTH('HELLO')-LENGTH(REPLACE('HELLO','L',NULL)) FROM DUAL;
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How do I turn a list into a table?
What is rownum and rowid?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What are the different types of constraints?
What is pragma in sql?
what is the difference between char_length and length? : Sql dba
What is difference between table and view?
How to fix oracle error ora-00942: table or view does not exist
What is the difference between clustered and non-clustered index in sql?
Inline the values in PL/SQL, what does it mean.?
Explain what is a view?
What is the usage of the distinct keyword?
What is a recursive stored procedure?
what is single byte over head in oracle..?
Explain autonomous transaction.
