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 run create database statement again?

1218

---

How to start your 10g xe server?

1087

---

Can a formula column be obtained through a select statement ?

2380

---

How to create a table index in oracle?

1184

---

Does oracle charge for java?

1115

---

How to use "startup" command to start default instance?

1101

---

How can Oracle users be audited?

1170

---

What is tns service name?

1177

---

What are named parameters?

1144

---

Is oracle a programming language?

1037

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2092

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2165

---

How to assign data of the deleted row to variables?

1115

---

How to grant create session privilege to a user in oracle?

1052

---

How do I connect to oracle database?

1198

---