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
Explain dml and ddl?
how to drop an existing table in mysql? : Sql dba
Is like operator in sql case sensitive?
How do I find duplicates in the same column?
Write the alter statement to enable all the triggers on the t.students table.
What are the built in functions of sql?
How long it takes to learn pl sql?
what is 'mysqlshow'? : Sql dba
What is the difference between a procedure and a function?
what are the differences between char and nchar? : Sql dba
What is pivot table in sql?
How do I save a sql query?
How you improve the performance of sql*loader? : aql loader
what is the difference between a having clause and a where clause? : Sql dba
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
