Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
Answers were Sorted based on User's Feedback
Answer / bhakti
select length(trim('ram charan singh')) - length (replace
(trim ( 'ram charan singh'),' ','')) +1 from dual
Is This Answer Correct ? | 19 Yes | 3 No |
Answer / sanjaya
select regexp_count('RAM CHARAN SINGH','s')+1 from dual;
Is This Answer Correct ? | 0 Yes | 0 No |
what are the advantages of running a database in NO archive log mode?
What is the difference between hot backup and cold backup in oracle?
How view is different from a table?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What are the general rules on data consistency?
What is the difference between "as" and "is" in an oracle stored procedure?
Calculate difference between 2 date / times in oracle sql?
How do I recompile a procedure in oracle?
What is save point in oracle database?
What is the order of defining local variables and sub procedures/functions?
How to drop an existing view in oracle?
Please explain the difference between outer join and inner join? With examples would be appreciable..!