select count('ram charan singh') dual;

Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3

Question Posted / joel

Answer Posted / joel

Is This Answer Correct ?

2 Yes

22 No

Please Help Members By Posting Answers For Below Questions

How do I uninstall oracle 11g?

1177

What are the types of partitions in oracle?

1078

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1093

What is meant by recursive hints in oracle?

1131

What are the general rules on data consistency?

1062

What is the data pump export utility?

1133

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2166

How to bring a tablespace online?

1143

Can you drop an index associated with a unique or primary key constraint?

1069

What is data file?

1150

How to unlock the sample user account in oracle?

1079

List the types of joins used in writing subqueries?

1037

How to define and use table alias names in oracle?

989

How do we get field details of a table?

1028

What is the difference between I and G in Oracle?

1150