Answer / Ravi Tewari

To recover a dropped table in Oracle, you can use the `FLASHBACK DATABASE` command if you have the Flashback Data Archive enabled. Here's an example:

```sql
ALTER SYSTEM FLASHBACK DATABASE TO BEFORE TIMESTAMP_IN_FORMAT 'DD-MON-YY HH24:MI:SS';
CREATE TABLE dropped_table AS SELECT * FROM flashback_table@scott.sh;
```
Replace `TIMESTAMP_IN_FORMAT` with the timestamp when the table was last present and `flashback_table@scott.sh` with the name of the Flashback Data Archive view for the dropped table.

7. Repeat query (7) but also display all clients who have never ordered anything.

1 Answers   Wipro,

---

How to use subqueries in the from clause in oracle?

1 Answers  

---

State the various uses of dbcc command?

1 Answers  

---

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

---

What is hash cluster in oracle?

1 Answers  

---

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

2 Answers   Wipro,

---

What are the differences between char and nchar in oracle?

1 Answers  

---

What is Network Database link ?

1 Answers  

---

What is the difference between normal and corelated subqueries?

2 Answers  

---

A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

2 Answers  

---

What is using clause and give example?

1 Answers  

---

What is a data segment ?

1 Answers  

---