I have the following update statement bt it is not working, even after leaving it for 16 hrs it dint end and neighter any of the records got updated
update
allele_temp
set
allele_temp.Aut oMarkerID =
(
select
distinct(marker _temp.AutoMarke rID)
from
marker_temp
where
marker_temp.dbS NPrsID = allele_temp.dbS NPrsID
)
where
...
lunas
Last Activity: Aug 29 '07, 11:25 AM
Joined: Aug 13 '07
Location:
-
update statement not working....
-
to update a table with values from another table
hi
i have to update a table based on a criteria with value selected from another table. i am writting a java progg for it . i just want to know can it be done with one statement.
my purpose is
result set rs =select (ID) from Tab1 where colmB is null
LOOP rs
select ID2 from tab2 where colC=ID
update tab3 set colD=ID2 where colC=ID and colD is null
end... -
to update a table with values from another table
hi
i have to update a table based on a criteria with value selected from another table. i am writting a java progg for it . i just want to know can it be done with one statement.
my purpose is
result set rs =select (ID) from Tab1 where colmB is null
LOOP rs
select ID2 from tab2 where colC=ID
update tab3 set colD=ID2 where colC=ID and colD is null
end... -
java.sql.SQLException: ORA-01006: bind variable does not exist
hi
i am trying to update a table selecting a value from another table and ve written the following codes for it..
import java.sql.*;
import java.io.*;
import java.util.*;
public class AF_updateAllele Tmp
{
Connection m_alleleCon;
public void con() throws SQLException, java.lang.Class NotFoundExcepti on
{
Class.forName(" oracle.jdbc.dri ver.OracleDrive r");...
No activity results to display