Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
- 3 Answers
- 6473 Views
- I also Faced
- E-Mail Answers
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 different types of database objects?
What do you understand by database schema and what does it hold?
What is a user account in oracle?
How to enter a new row into a table interactively?
how to get last monday of a month?
Is it possible to enter only time value into a column of a table in sql?
Display Odd/ Even number of records?
Define the terms primary key foreign key and also the difference between primary and the unique key
What is the function of Optimizer ?
How a database is related to tablespaces?
Can we create more than one constraint to column ?
How to lock and unlock a user account in oracle?
Oracle General 
