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
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is a composite primary key?
What is compound trigger?
What is mutating sql table?
How do I edit a trigger in sql developer?
What is a temp table?
What are the basic sql commands?
What is right join sql?
What are the different types of dbms?
Is inner join faster than left join?
What is normalization sql?
How do you write a subquery?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
does sql support programming? : Sql dba
What is dynamic sql in pl sql?