How to update all records of all tables in database?
<p>I have a table with a lot of records (could be more than 500 000 or 1 000 000). 
I want to update some common columns with the same field name in all tables throughout the database.</p>

<p>I know the traditional way to write separate queries to individual tables but not one query to update all records of all tables.</p>

<p>What is the most efficient way to do this in SQL, without using some dialect-specific features, so it works everywhere (Oracle, MSSQL, MySQL, Postgres etc.)?</p>

<p>ADDITIONAL INFO: There are no calculated fields. There are indexes. Used generated SQL statements that update the table row by row.</p>