SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to update multiple tables when column name is same

549760Feb 23 2009 — edited Feb 23 2009

Hi,

I have some 22 tables whose column neet to updated. can I update all the tables in a single update statement?

ex: update table1,table2 set rqstid=rqstid||'EQ' where rqstid in ('111','2222'); (rqstid is the name of the column present in table1,table2)

Please help me. Instead of writing 22 update statements can I use single update stmt for all the tables.

Regards,
Chanda

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2009

Added on Feb 23 2009

6 comments

832 views