Updating two tables in oracle


16-May-2020 14:37

You can specify this clause for tables and materialized views and for views with a single base table.The Ask TOM team will be busy at Open World this month.Here is the sample example of how the transaction should work with multiple update statements.Let me know if this solution satisfies the need of updating two tables in a single statement.CREATE TABLE source_tab AS SELECT object_id, owner, object_name, object_type FROM all_objects; ALTER TABLE source_tab ADD ( CONSTRAINT source_tab_pk PRIMARY KEY (object_id) ); CREATE TABLE dest_tab AS SELECT object_id, owner, object_name, object_type FROM all_objects WHERE ROWNUM statement, but in a row-by-row manner.The third performs an update, and conditionally inserts the row if the update touches zero rows.

the rows of both tables have the same columns and i have to check if the key columns exist then i update the rest of the columns , otherwise i insert the new row.Pinal is also a Cross Fit Level 1 Trainer (CF-L1) and Cross Fit Level 2 Trainer (CF-L2).