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

PHP not creating file.
Its supposed to create a .ini file in the /scriptfiles/users/ with the name they entered into the fi

Is this Safe or Unsafe?
Hi i made a few pages with lots of peoples help now i just want to know if they are safe or not can

Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que

Creating XML with php
I need to creat an XML with php and have successfully produced a valid output.
The problem I hav

I am stumped
OK. Here is what I am trying to do. I have the conditions set, and if the conditions are met, I want

understanding functions and classes
Code: [Select]
class person {
var $name = "Jimmy Goe";

function get_nam

cPanel API
Hi Guys,

Need a little guidance. I'm trying to get my script to communicate with cPanel (or W

PHP switch function help
Hi, I am trying to create a search function for a directory website. On the search function on html

insert quotes
Hi,

I have an output like this:
Code: john,18,Cancer
How can I change this to
Code:

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi