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 to assign a table row to a record variable?

965

---

What is the difference between "as" and "is" in an oracle stored procedure?

931

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2218

---

What is recovery manager in Oracle?

992

---

Why does for update in oracle 8 cause an ora-01002 error?

932

---

How to call a stored function with parameters?

968

---

What is tns entry?

1058

---

What do you understand by database schema and what does it hold?

1177

---

What is translate in oracle?

1048

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1617

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2573

---

How to connect the oracle server as sysdba?

1008

---

Will you be able to store pictures in the database?

1061

---

What is index-organized table in Oracle?

1018

---

Explain the use of owner option in exp command.

989

---