Answer / sumanamara

2)
select length('HELLO')- length(replace('HELLO','L',''))
FROM
dual;

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

---

Is sql pronounced sequel or sql?

0 Answers  

---

four procedures is are there should i write their in a package

2 Answers  

---

Is sql database free?

0 Answers  

---

What is nosql db?

0 Answers  

---

---

What does <> sql mean?

0 Answers  

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

0 Answers  

---

How do you clear the screen in sql?

0 Answers  

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

---

What is cte?

0 Answers  

---

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

Explain commit, rollback and savepoint.

0 Answers  

---