Oracle bulk update table from where clause -

Oracle bulk update table from where clause -

i have master (md_ts_mast) contains

mast_id eng_id ms_date

detail (md_ts_detail) table

id md_id (rel mast_id) job_for job_type_id account_id

below sql locates "md_ts_detail ids" eng_id , date range. gets me details of. 102038 102134 101970 102244

then need update md_ts_detail table.

update md_ts_detail set job_for ='25', job_type_id ='344', account_id ='8' md_ts_detail.id in ( select d.id md_ts_mast m left bring together md_ts_detail d on m.mast_id = d.md_id eng_id = '621' , ms_date between '02-oct-14' , '05-oct-14'; )

this converted form. mind has gone blank on how update this.

looks ive had much coffee.

i added semi_colon before closing bracket (oops). removed , worked fine

oracle sql-update