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;

Difference between cartesian join and cross join?

544

---

How to execute the package in oracle?

572

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

1706

---

What are joins, explain all types of joins?

1724

---

What are the numeric comparison operations?

633

---

---

What is a table index?

566

---

What is a data lock in oracle?

615

---

How do I reset a sequence in oracle?

600

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1927

---

what is dynamic SGA and static SGA

3845

---

What are ddl statements in oracle?

592

---

How to retrieve data from an explicit cursor?

560

---

What is the difference between $oracle_base and $oracle_home?

585

---

Explain oracle left join with an example?

589

---

if you ctreate table identity

1847

---