Answer Posted / saisivakumar

select <column_name>,to_char (<column_name>,'fmdd month
yyyy fmhh:MI:ss am') from <table_name> where
condition;

Note: i have given for both date and time, pls use as u
want.

What is the quickest way to export a table to a flat file?

969

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2974

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2073

---

How to create a new table by selecting rows from another table?

1103

---

What is a cursor variable?

1137

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2193

---

What is a nested table and how is it different from a normal table?

1057

---

What is backup in Oracle?

1008

---

What is the difference between substr & instr functions?

1233

---

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

1170

---

What is the maximum number of triggers that can be applied to a single table?

1029

---

What are the advantages of oracle?

1029

---

What is the difference between substr and instr?

1042

---

What are the limitations oracle database 10g xe?

1047

---

What is a trace file and how is it created in oracle?

1062

---