Answer Posted / nirmala.s

In oracle,
if u use DATE, u can get the date,
if u use TIME, u can get time

if use time space , u can get both date and time even
in milli sec ALSO(HH:MM:SS:MS)

Is there any function in oracle similar like group_concat of mysql?

1109

---

How to do clean up if create database failed?

1071

---

What are a cluster and non-cluster index?

1065

---

Is oracle an operator?

986

---

What is a nvl function?

1097

---

What to do if the startbd.bat failed to start the xe instance?

1128

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2341

---

What is the difference between $oracle_base and $oracle_home?

1137

---

How to pass parameters to procedures?

1089

---

Explain the dml?

1051

---

How to drop an existing view in oracle?

992

---

What is the dynamic sql in oracle?

1136

---

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

2320

---

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

4572

---

What is partitioned table in Oracle?

1272

---