Answer / krishh

Yup can get it using 'FLASHBACK QUERY'.....

SYNTAX:

Flashback Table <tablename>

Answer / kd

Using flashback query
select * from t1 as of scn 1234567;
Using flashback transaction query to get undo sql.
Using flashback table to scn/timestamp

Answer / david

@SWATI....


may i know how will u get this ...explanation plzzzz....


gunjan david.

Answer / swati

Yes we can get the deleted Record again if the delete
transaction has been committed. Since delete is a DML
command, so it can be triggered back, as well as Rolled
back also.

I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

4 Answers   Icon,

---

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

0 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

0 Answers  

---

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---

How do you create a credit note against an invoice? : oracle accounts receivable

0 Answers  

---

Name two files used for network connection to a database.

1 Answers  

---

What Are Cross Validation & Adi?

0 Answers   Oracle,

---

please explain about oracle

1 Answers  

---

8. Supporting AP, AR and GL?

0 Answers   Oracle,

---

wht r the base tables & primary key for BOM& WIP modules

1 Answers   Satyam,

---

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

0 Answers   HCL,

---