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
Can't find the problem (no error message)!
OK, here's the deal. This code is really weirdly formatted (sorry!) and hard to understand, so I'm going to try and make it as easy as possible. Here's a breakdown of what the user should do:1. The
Gantt Chart Tool
Does anyone know of a good free gantt chart creator toolThanks
Email Script does not reach destination
Hey Guys look at this code snippet :Code: //read a line from the file$myFile = "MailFile.txt";$fh = fopen($myFile, 'r');$theData = fgets($fh);fclose($fh);echo $theData;/send Email$to =
first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have seen this in many news sites where the news story headline reads like "woman found in obama's
Word Trimming
Hi Guys & Gals!!Hope you are all ok....I need some help with the followingI need to trim the following word as follows:$word = 'James Bond';output would be 'James B'There is a space between
Help adding strtolower( to my in_array
strtolower i need to add it to this to work, iuno how.Code: $moderators = array('Admin', 'banana', 'orange');if (in_array("{$_SESSION['user_name']}", $moderators)) print('Found it!');i
natcasesort works on one server but not on another
HiI have a problem that I was hoping that someone can help me with.I'm trying to use natcasesort() to sort an array. This works fine on my laptop (which I use for testing and which uses php 5.2.6),
How to kill asynchronous postback / current postback?
Hi,here is my problem:I have a web site with many pages of which some may take time to process results. If a user wants to go to another page (by clicking on the top menu) the browser locks up till
Deleting a record php
Attempting to setup delete a record page. The below code I put together doesn't seem to work. | <?$delid=$_GET['delid'];echo $delid;if(isset($_POST['submit'])){$delquery="DELETE FROM table
help with php
It's not displaying or pulling anything out of the database. Code: <html><head><title>Hale's Music World: Inventory Search
