quick question about System Change Number(SCN) in FlashBack Query topic

Posted on 16th Feb 2014 07:03 pm by admin

i know tht we can get the SCN of the database using flashback concept as follows

SQL> execute :myvariable:=dbms_flashback.get_system_change_number();

PL/SQL procedure successfully completed.

SQL> print myvariable;

MYVARIABLE
451578

for example i made some insertions into a table after this and commit is executed. If i want to rollback this transaction thn i can use

SQL> execute dbms_flashback.enable_at_system_change_number(:myvariable);

PL/SQL procedure successfully completed.

but what if i dont know the SCN of the database before the transaction(insertion in to the table). If i want to rollback the database to state where i don't know the SCN of that particular state, thn how can i do tht.

i know tht we can do it using timestamp method....but i want to know how we can use this SCN concept in this situation.
Thanks

Your Answer:

Login to answer

Other forums

Gerenate tabel in Php
I whant to generate a tabel takeing data from database like this one so the results to be display on

function to return url
Hi,

Can you guys help me giving a function that takes all the contents in a particular field

SQL Injection
In my attempts to protect my database from mySQL injection I have created another problem for myself

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

puting for loop in 1 value
hi ,

how do i put this code in 1 value:
Code: <?php
for ($i=1; $i<=5; $i

Just a white page
Okay so, my website, when I click SignUp on it it takes me to /join.php but its a complete white pag

Web Application Recipe
Hi Guys!

I am working with the Web Application recipes. I am currently working on the sen

Really need helps regarding Pagination with Sort
I need someone helps regarding pagination problem...i actually want to make my page limited to let s

Add User script "Could not execute query"
This should be an easy script but I can't get it to run. Can someone please help me?

<

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I