Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 Answers  

---

How to get a list of all user accounts in the database?

0 Answers  

---

How many different types of indexes we have in oracle?

24 Answers   IBM, TCS,

---

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers  

---

How to display First 4 rows From Database Table?

6 Answers  

---

How do I know if oracle is installed on windows?

0 Answers  

---

what are corelated subqueries

1 Answers   Global Infotech,

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---

What is a system tablespace and when it is created?

0 Answers  

---

What does a Control file Contain ?

2 Answers  

---

How can I get column names from a table in oracle?

0 Answers  

---

How to see free space of each tablespace?

0 Answers  

---