Answer Posted / serena

Using flashback table:
# enable row movement
1) alter table test2 enable row movement;
# flashback test2 to 10 minutes ago.
2) FLASHBACK TABLE test2 TO TIMESTAMP SYSTIMESTAMP -
INTERVAL '10' MINUTE;

How to drop an existing table in oracle?

1012

---

How to write a left outer join with the where clause in oracle?

1024

---

Difference between oracle's plus (+) notation and ansi join notation?

1031

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1322

---

What is a system tablespace and when it is created?

918

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1943

---

How to find out what oracle odbc drivers are installed?

977

---

What privilege is needed for a user to query tables in another schema?

918

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2995

---

Explain what are the different type of segments?

911

---

How are extents allocated to a segment?

1061

---

How to create a new tablespace in oracle?

932

---

What are the parameters that we can pass through a stored procedure?

996

---

Why do we use coalesce function in oracle?

1050

---

Difference between the “verify” and “feedback” command?

1308

---