How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

What is the oracle implicit cursor?

0 Answers  

---

12. Display the client name in upper case only and in lower case only.

1 Answers   Wipro,

---

What is blob datatype?

0 Answers  

---

How to use subqueries in the from clause in oracle?

0 Answers  

---

hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,

---

What is Partitions in Table ?

2 Answers   Atiric Software,

---

How to write a query with a full outer join in oracle?

1 Answers  

---

How many types of auditing in Oracle?

0 Answers   MCN Solutions,

---

What is a shared pool?

1 Answers  

---

How to write text literals in oracle?

0 Answers  

---

What is Parallel Server ?

3 Answers  

---