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.

How do I start tns listener?

1023

---

how to clone 9i Database on to 10g Database.

2319

---

Explain the function of optimizer in oracle?

1103

---

How will you write a query to get a 5th rank student from a table student_report?

1842

---

How to list all user accounts in oracle?

1007

---

Explain about functional dependency and its relation with table design?

987

---

In the oracle version 9.3.0.5.0, what does each number shows?

1278

---

How to display employee records who gets more salary than the average salary in the department?

1036

---

How to view the data files in the current database?

1078

---

Hi Can any one tell me what are the API's used in requisition import.

1909

---

How to save query output to a local file?

1004

---

What is the use of aggregate functions in oracle?

1012

---

How can you merge two tables in oracle?

967

---

What is the difference between count (*), count (expression), count (distinct expression)?

988

---

What is proxy method?

956

---