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
C++ API to Oracle dB
I need to perform a select command to the Oracle dB to obtain information from a table.What libraries can I link into my project to make this work?I read about the OCI - but I cannot find any
Quick Question about echo value
Hey guys, I'm trying to get something to show differently in one of my scripts. I'm trying to make it so that people that are a certain rank in my game will have their names show up bold in the users
type check while uploading
Hi Everyone,How can I check the exact type of a file while uploading on my site?Here is the scenario:I have allowed only .jpg, .gif, .png files to be uploaded on my site. Suppose an user renames his
Which practice of iteration through containers is preferred
In the "real world" what kind of loop do most people use to iterate through a container like a vector.A loop like this... Code: for (int i = 0; i < v.size(); ++i) { // do whatever}Or like
Checking BOM Authorization Group
Hai Friends,
update 2 columns by doing inner 2-column query
Hi,
A Few Questions
Hi, I want to ask a few questions that I can't seem to find..1) I'm creating a "shortcut" system on my website, where users can add shortcuts from pages by clicking the link and it will
INSERT for date range
Hi allI have the following tableCode: [Select] `date` date `day` int(2) `month` int(2) `year` int(4)If I pass a date range in PHP, such asCode: [Select]$datefrom = '2009-02-20';$dateto =
reating a background image
I am building a site in drupal and have a php form in it, due to certain annoyances with module building I need to generate a background image and margin for my form in PHP and, whilst i imagine this
Error with login script
I am getting an error with my login script:Error:Code: Warning: Cannot modify header information - headers already sent by (output started at /home/bucket/public_html/inc/config.php:7) in