Dear Lazy DBA's



Is there any reason why the update statement below would not work.

besides the usual suspects-

I have a po_number in pop_lines where po_line_number = 1 and The
description field is blank

I also have a, identical po_number and po-line_number in temp_pop_lines
where the description is populated.



I get no errors, 'update complete' and then I commit. Yet the change
does not seem to take.



Any ideas?? Thank You

Regards

Jim Thomas







1 update pop_lines p

2 set p.purchase_line_detail_descr = (SELECT
purchase_line_detail_descr

3 FROM temp_pop_lines t

4 WHERE t.po_number =
p.po_number

5 and t.po_line_number =
p.po_line_number)

6 ;

7 commit

8 ;




Oracle LazyDBA home page