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)

What is a static data dictionary in oracle?

1108

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2343

---

Is oracle the best database?

962

---

Can group functions be used in the order by clause in oracle?

993

---

What is merge statement used for?

1022

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4358

---

How can we delete duplicate rows in a table?

971

---

what is dynamic SGA and static SGA

4413

---

What is oracle datasource?

980

---

What are the oracle differences between nvl and coalesce

1145

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2147

---

Why does oracle 9i treat an empty string as null?

1050

---

What are nested tables?

1168

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2255

---

What is raw datatype in oracle?

1130

---