Answer / bhakti

select length(trim('ram charan singh')) - length (replace
(trim ( 'ram charan singh'),' ','')) +1 from dual

Answer / sanjaya

select regexp_count('RAM CHARAN SINGH','s')+1 from dual;

Answer / joel

select count('ram charan singh') dual;

How many anonymous blocks can be defined?

0 Answers  

---

What is an oracle recycle bin?

0 Answers  

---

how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

2 Answers   BOB Technologies, Cap Gemini, IBM,

---

Explain oracle left join with an example?

0 Answers  

---

How to execute the package in oracle?

0 Answers  

---

How to export several tables together?

0 Answers  

---

pls explain connect by prior with example and its real time use

3 Answers  

---

Explain self joins in oracle?

0 Answers  

---

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

---

Difference between NO DATA FOUND and %NOTFOUND?

1 Answers  

---

What is an oracle wallet?

0 Answers  

---

How to restrict the duplicate records in table valuesets

2 Answers   IBM,

---