Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Question -> how to insert values into a table bases on seconds
Here is my problem.... I need to insert information in a temp table.
My table is called tres_l_0197
Two users at the same time (first one at 9 Oclock and second one at 9h05 ) will execute a report that is called res_l_0197 and the report will store info in the table tres_l_0197.
Both report will insert into tres_l_0197 the SAME information
Ex: Anna Kennedy and all her info will be store TWICE in tres_l_0197.
And the two report HAVE to print all the information on their printer. My problem is that the report will print the information no problem but in DOUBLE. Anna Kennedy will be print two time instead of only one because her name is stored twice in the table..
My question is HOW can I store the information in table tres_l_0197 wtih two people executing the same report at the same time WITHOUT printing the information in double.
THANKS ALL IN ADVANCED AND PLEASE I NEED THIS QUICK..
ARGGGG
Ghis
Zembla_at_cam.org
Received on Wed Jan 14 1998 - 00:00:00 CST