5000000 order by att_tran_id desc"; $stid = oci_parse($conn, $sql); while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) { ECHO $row['ATT_TRAN_ID']; $sql1="update daily_attendance set att_tran_id=".$mxid." where att_tran_id=".$row['ATT_TRAN_ID']; $stid = oci_parse($conn, $sql); $stid = oci_parse($conn, "commit"); $sql1="update daily_ebmc_attendance set att_tran_id=".$mxid." where att_tran_id=".$row['ATT_TRAN_ID']; $stid = oci_parse($conn, $sql); $stid = oci_parse($conn, "commit"); $mxid++; } ?>