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
Help with form post data and arrays
Hi all,I am new to this forum... It has been awhile since i have worked with arrays, and i am starting to pull my hair out with this little issue i am having..I hope someone can help me out with it,
how to get values from $_Post with onchange="form.submit();"?
Hi, I have a form that submit to itself with a file upload field and two other hidden field values.If I put a submit button on the page, all is working fine.I don't like the submit button as its
array_map() probably obvious mistake
The code below is part of a class to escape strings, but should also accept an array, using array_map() to do the job. Unfortunately, passing an array results in the original, unescaped array being
chat
hello i'm amir
Storing/displaying image urls in a database?
HiBasically I have the following scenario:User chooses picture from list. Picture info is added into the db, including url.However I can't figure out how exactly i should be storing the url for the
Help with looping
I have a comma separated list of colors taken from a database ($ICo) and a directory of images named "color". The images are named the "color.jpg"I am attempting to loop through
How to assign a textbox value to PHP variable??
Hi ! Can any one help me out as quickly as possible. As I m new to PHP.Plz tell me how to assign a textbox value to PHP variable on a same PHP page with out POSTING data to other page e.g:$tbVal =
PEAR in appliactiond development
When I was picking up PHP I went from procedural programming, fairly quickly into OOP, then after writing a bunch of custom libraries and applications I discovered CodeIgniter. I pretty much
Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't workWhich part is
Help =( !! Upload Pics [PHP script]
HelloI need help with a php script [MULTIPLE UPLOAD IMAGES] , where I want to add a feature (watermark the uploaded pictures) , thats mean its watermark & upload in the same time . look this