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  

---

dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

3 Answers  

---

3. Display all the client numbers in the ORDER table. Remove duplicates.

1 Answers   Wipro,

---

How to increment dates by 1 in oracle?

0 Answers  

---

What are temporal data types in oracle?

0 Answers  

---

How to count groups returned with the group by clause in oracle?

0 Answers  

---

How to drop an existing view in oracle?

0 Answers  

---

What is MTTR advisor in Oracle?

0 Answers   MCN Solutions,

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

0 Answers  

---

How to write a left outer join with the where clause in oracle?

0 Answers  

---

various types of hints and their usage

0 Answers  

---

What is oracle open database communication (odbc)?

0 Answers  

---