Answer Posted / attitude girl

Ofcourse Its Possible in New ORACLE 10g EDITION
you have to use flashback command for this.

Syntax:

FLASHBACK TABLE YOURTABLENAME TO BEFORE DROP;

LIKE
FLASHBACK TABLE EMP TO BEFORE DROP;
FLASHBACK COMPLETE.


YOU'LL BE AMAZED BY THIS.
THE BEST THIG IS THAT IT'LL EVEN GET YOUR DATA BACK AS WELL.

TRY THIS COMMAND.

what are the tools used for oracle 10g in real time.

2493

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7777

---

where the dff data will be stored

2540

---

Explain the payment term in ar. : oracle accounts receivable

1151

---

What is the sql query to find the employee who has Nth maximum salary?

5430

---

How would you determine what sessions are connected and what resources they are waiting for?

2179

---

How would you determine who has added a row to a table?

2386

---

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3999

---

can u give guidance abt packages of plsql

2240

---

3. Steps in UAT?

2481

---

what is difference between inner join & nested query or subqueries

3114

---

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1479

---

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2559

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2335

---

How to clone the database using RMAN back

2316

---