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  

---

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

1 Answers   Goldman Sachs,

---

What do you mean by group by clause?

0 Answers  

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

0 Answers  

---

How many memory layers are in the shared pool?

1 Answers  

---

---

What is system tablespace?

0 Answers  

---

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  

---

What are the components of logical database structure in oracle database?

0 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

Explain the use of log option in exp command.

0 Answers  

---

How to define an oracle cursor variable?

0 Answers  

---

What is the data pump import utility?

0 Answers  

---