Re: PL SQL logic please

trsspk_at_gmail.com wrote:
> I have two tables:
>
> test_pick (headerid,lineid,item,qty_ordered,qty_shipped)
> test_recv
> (headerid,item,qty_shipped,status)
>
> issue here is, i have to update test_pick table qty_shipped column from
> test_recv qty_shipped column.
>
> since you guys already might have noticed qty_recv has no line id.
>
> if i don't get item number repeated for one header I'm very fine.
>
> but for one header, possibility is there to have items repeated. and
> the qty ordered may not match to qty shipped. it could be same/less or
> more.
>
> hope its not a big challenge for you gurus to help me out hinting
> pl/sql logic flow.
>
> appreciate all your help.

I agree with Sybrand ... the design makes no sense. If your instructor designed this get a new instructor. If you designed this fix the design.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org