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 can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

2 Answers   Verizon,

---

What are the uses of Rollback Segment ?

2 Answers  

---

13. Display the second to fifth characters in each client name.

2 Answers   Wipro,

---

what are different types of deletes?

1 Answers  

---

Explain parameter file in oracle.

0 Answers  

---

what is the syntax of DELETE command?

8 Answers  

---

what are the advantages of running a database in archive log mode?

0 Answers  

---

How to find out what oracle odbc drivers are installed?

0 Answers  

---

how to delete all duplicate records from a table using subquery?

7 Answers   ABC, Cap Gemini,

---

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

4 Answers   Infosys,

---

How to define a data source name (dsn) in odbc manager?

0 Answers  

---

What is the difference between Outer join and Full outer join?

5 Answers  

---