plsql - Comparing two tables, if rows are different, run query in Oracle -


Think about both of the tables in the same column. I is a column id, and the second text is the following pseudo code in PSDLL Is it possible to implement?

  Compare each line (they will have the same ID) If there is anything different about them, then run some questions: an update, and otherwise insert if they are the same Nothing, but the row is not present, so add a row to the table compared to  

. Do this logic of whether it is easy to use PLSQL or make me a standalone application.

Your table contains the same columns, you can easily check whether two equal lines are the same or not - - If your column is added to a column then there is no need to update your code.

In addition, you allow to search the rows in a table, but not in the other.

Therefore, you can use something to achieve your purpose:

  for REC (SELECT T.ID ID1, U.ID ID2, V EQ to T Full Over User on T. ID = UIID Full External Join (Select ID, 1 EQT Nettick Join You) VO UIID = V.ID) if Rick is on the Loop. ID 1 is Zero - U in line but not in TLSEF REC ID 2 is empty - line in T, but U LSEF Rick. The blank line is present in both rows - but the ending end of the end if the end loop  

Comments