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 use subqueries with the exists operator in oracle?

1071

---

List the parts of a database trigger.

1109

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4572

---

What is a sub query? Describe its types?

1074

---

How to pass parameters to procedures in oracle?

1083

---

What are the uses of linked server and explain it in detail?

1118

---

How to run create database statement again?

1221

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5683

---

Explain the importance of .pll extension in oracle?

1061

---

What are joins, explain all types of joins?

2364

---

Name the three major set of files on disk that compose a database in Oracle?

1172

---

Explain a synonym?

1089

---

Please explain oracle left join with an example?

1095

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2760

---

What is max rowid in oracle?

1084

---