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  

---

is database gud carrier option??

1 Answers  

---

How to write date and time interval literals in oracle?

0 Answers  

---

How do you ensure database security?

1 Answers  

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

0 Answers  

---

how to create a new database in oracle?

6 Answers   TCS,

---

What is proxy method?

0 Answers  

---

wirte the syntax of update query?

3 Answers   IBM,

---

What is a Shared SQL pool ?

2 Answers  

---

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

1 Answers   Wipro,

---

Explain overloading. Can functions be overloaded?

0 Answers  

---

How do I learn what codesets are available in oracle?

0 Answers  

---