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;

Difference between cartesian join and cross join?

0 Answers  

---

How to create an initialization parameter file?

0 Answers  

---

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 Answers  

---

Explain what are the different type of segments?

0 Answers  

---

10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.

3 Answers   Wipro,

---

What is a Redo Log ?

3 Answers  

---

How to get the Installed Oracle Version Information ?

0 Answers   MCN Solutions,

---

WHAT IS ecc 6.0

0 Answers  

---

What is cursor

4 Answers   TCS,

---

What is a system tablespace and when it is created?

0 Answers  

---

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---

what is the use of composite key constraint?

2 Answers  

---