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
Just wondering what you think about my site
I am new to phpfreaks i just seen this form and thought it would be cool to see what other thought about my site, feel free to sign up an post items to see how that all works or if you dont want to
Storing Values taken from a DB...
Using this code it will generate a short list from my database <?phpmysql_connect('localhost','root','');mysql_select_db("clients");$fname = $_POST['firstname'];$SQL = "SELECT *
HTML Viewer HIDE scrollbar
How can I disable scrollbars in a HTML Viewer control? I can't hide them. Even i have enough space but i am getting this grey inactive scrollbar....
Hyperlink is adding an extra gap to variable
Hi, here's my problem..I have a php generated page with a hyperlink which opens in a new windowecho "<tr><td><a
Need Successful Return
Hello I am currently working a form here, and I have everything figured out except when I click the return button from my preview view. the information is lost in all the textarea's. Any clue what I
Calling All PHPFREAKS Blackberry Users
Are you a member of PHPFreaks and have a blackberry? Well RIM just recently released Blackberry Messenger 5.0! What does this mean for you, the user? It means that you have all sorts of cool new
Is there a way to override built in php functions without APD?
I am trying to use the rename_function()override_function() options that are built into the APD php extension. But I don't want to rely on that extension being loaded.This is another one of my
login form can you find my error?
registrationform.php seems fine send data to registration.phpregistration.php seems fine checks all data then send it to function.phpconnection.php does its job and connects to database also calls
Table trouble
i have been reading the forum for a few weeks and decided to join. i like the format and the advice given is great. anywho here is my table, the issue i have is that i am displaying pictures from
question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.I have roughly 30 files. I want to be able to edit every $_POST and $_GETCode:
