Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
Answer Posted / bhakti
select length(trim('ram charan singh')) - length (replace
(trim ( 'ram charan singh'),' ','')) +1 from dual
Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
How do you find current date and time in oracle?
How can we find out the duplicate values in an oracle table?
How to apply filtering criteria at group level in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
What are the types of trigger in oracle?
What types of joins are used in writing subqueries?
What is ASM (Automatic Storage Management) in Oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to drop an existing table in oracle?
How can Oracle users be audited?
Explain the use of grant option in imp command.
How do you store pictures in a database?
How to drop an index?
What do you mean by merge in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?