QUERY
- From: "Seema Singh" <oracledbam@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Apr 2004 21:44:30 -0400
Hi
Any advice are welcome.
update main_test a
set a.directions =(select b.access1 from trail_main b
where b.trail_name = a.trail_name
and b.trail_code = a.trail_code)
This is updating 6595 rows.
update main_test a
set a.directions = (select access1 from trail_main b
where a.trail_name = b.trail_name
and a.trail_code = b.trail_code )
where a.trail_id = ANY (select a.trail_id from
vw_trail_main_test a, trail_main b
where a.trail_name = b.trail_name and a.trail_code
= b.trail_code )
This is updating 2599 rows updated.
When I select
select b.access1 from trail_main b
where b.trail_name = a.trail_name
and b.trail_code = a.trail_code
It returns 2599 rows.
Wondering what is wrong?
thx
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar ? get it now!
http://toolbar.msn.com/go/onm00200415ave/direct/01/
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
