I got error like "ORA-00971: missing SET keyword" why?

[sri devi]

Dear all,

My Query is below,

Update iz_zone, iz_page, iz_object_zone, iz_page_inv SET iz_zone.to_spg = 1,iz_zone.from_spg = 1,iz_page.spg_no=1,iz_object_zone.to_spg = 1,iz_object_zone.from_spg = 1,iz_page_inv.src_pg_no = 1 where iz_page.page_inv_id = iz_page_inv.page_inv_id and iz_zone.page_id = iz_object_zone.page_id and iz_zone.page_id = iz_page.page_id and iz_object_zone.page_id = iz_page.page_id;

Kindly, help me frnds. Its very urgent task......

Regards,
Sri Devi S

[sams haja]

Tried, also getting the same result.

[amitpatel66]

Check UPDATE Statement Syntax from oracle documentation.

[Sandeep M]

cannot use multiple tables in a single UPDATE statement.

"Update iz_zone,
iz_page,
iz_object_zone,
iz_page_inv " invalid

You can update mutiple tables using triggers.