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 happens to the current transaction if the session is ended?
How to view the tablespaces in the current database?
How to display First 4 rows From Database Table?
What is rowid and rownum in oracle?
Differentiate between translate and replace?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
How to do a full database export?
Can we write insert statement in function in oracle?
How to apply filtering criteria at group level in oracle?
What is max rowid in oracle?
What happens if recursive calls get out of control?