On Nov 19, 3:43 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> pal schrieb:
>
>
>
>
>
> > UPDATE paywork
> > SET ot1_hrs = 0,
> > ot1_amount = 0,
> > ot2_hrs = 0,
> > ot2_amount= 0,
> > ot3_hrs= 0,
> > FROM paywork,
> > emp_master
> > WHERE ( paywork.emp_code = emp_master.emp_code ) AND
> > ( emp_master.loc_cd like :is_loc_cd ) ;
>
> > this code is giving me error..
>
> > Whether i can use "From" in an update query? cos SQL plus is giving
> > an error message on that,
>
> > if i'm not using the from i cant check the condition on where clause.
>
> > Can any one tell me what i can do for this
>
> Probably, something like this should work for you:
>
> UPDATE paywork p
> SET ot1_hrs = 0,
> ot1_amount = 0,
> ot2_hrs = 0,
> ot2_amount= 0,
> ot3_hrs= 0
> WHERE EXISTS (
> SELECT null
> FROM emp_master e
> WHERE ( p.emp_code = e.emp_code )
> AND ( e.loc_cd like :is_loc_cd )
> )
>
> UPDATE syntax can be looked athttp://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statem...
>
> Best regards
>
> Maxim- Hide quoted text -
>
> - Show quoted text -
thank you maxim
Received on Mon Nov 19 2007 - 06:30:09 CST
