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 select second mauximum value in a given table under salary column

6 Answers   Sapient,

---

What is the difference between Sleep and Wait? (Java)

1 Answers   RBS,

---

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,

---

what is dynamic SGA and static SGA

0 Answers   Oracle,

---

What is Database Buffers ?

1 Answers  

---

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

2 Answers   Wipro,

---

Which database is better for os platform dependency?

1 Answers  

---

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers   IBM,

---

How to create a temporary table in oracle?

0 Answers  

---

What is the use of oracle?

0 Answers  

---

What are the parameters that we can pass through a stored procedure?

0 Answers  

---