For a same table structure, the process of comparing two database if consensus is not change, if inc-CodePudding

For a same table structure, the process of comparing two database if consensus is not change, if inconsistent, generate increased authorization statement to a table

A table in A database A and database B of A table by comparison, if inconsistent, generate an authorization statement, on the process of how to write A C table, oracle beginner rookie, beg god for

CodePudding user response:

Through two libraries all_tab_columns table query you want DDL statements, loops,

CodePudding user response:

reference 1st floor nayi_224 response:

through two libraries all_tab_columns table query you want DDL statements, loops,

A great god, and can understand some

CodePudding user response:

refer to the second floor qq_29895367 response:

Quote: refer to 1st floor nayi_224 response:

Through two libraries all_tab_columns table query you want DDL statements, loops,

A great god, and can understand some

Just wrong, it should be a matter of synchronous data, the demand again say clear point, some examples,

CodePudding user response:

reference nayi_224 reply: 3/f

Quote: refer to the second floor qq_29895367 response:

Quote: refer to 1st floor nayi_224 response:

Through two libraries all_tab_columns table query you want DDL statements, loops,

A great god, and can understand some

Just wrong, it should be a matter of synchronous data, the demand again say clear point, some examples,

So, I now have two databases, for example, A database A and b. A database the two database has A table of the same structure, now I want to contrast the two database table data is consistent, if inconsistent, generates A DDL statement, endures C table, for such A process, and I know there was A table data contrast of pl/SQL operations, but special cases can't use,,, alas

CodePudding user response:

reference 4 floor qq_29895367 response:

Quote: reference nayi_224 reply: 3/f

Quote: refer to the second floor qq_29895367 response:

Quote: refer to 1st floor nayi_224 response:

Through two libraries all_tab_columns table query you want DDL statements, loops,

A great god, and can understand some

Just wrong, it should be a matter of synchronous data, the demand again say clear point, some examples,

So, I now have two databases, for example, A database A and b. A database the two database has A table of the same structure, now I want to contrast the two database table data is consistent, if inconsistent, generates A DDL statement, endures C of table, and such A process, I know there was A table data contrast of pl/SQL operations, but special cases can't use,,, alas

Inconsistent, generate a what kind of statement? A concrete example

CodePudding user response:

reference 5 floor nayi_224 reply:

Quote: refer to 4th floor qq_29895367 response:

Quote: refer to the third floor nayi_224 response:

Quote: refer to the second floor qq_29895367 response:

Quote: refer to 1st floor nayi_224 response:

Through two libraries all_tab_columns table query you want DDL statements, loops,

A great god, and can understand some

Just wrong, it should be a matter of synchronous data, the demand again say clear point, some examples,

So, I now have two databases, for example, A database A and b. A database the two database has A table of the same structure, now I want to contrast the two database table data is consistent, if inconsistent, generates A DDL statement, endures C of table, and such A process, I know there was A table data contrast of pl/SQL operations, but special cases can't use,,, alas

Inconsistent, generate a what kind of statement? A concrete example

Inconsistencies, such as A table is A more than B data, generate the insert statement, if the data is consistent, then update the data, delete temporarily not considering

CodePudding user response:

refer to 6th floor qq_29895367 response:

Quote: refer to the fifth floor nayi_224 reply:

Quote: refer to 4th floor qq_29895367 response:

Quote: refer to the third floor nayi_224 response:

Quote: refer to the second floor qq_29895367 response:

Quote: refer to 1st floor nayi_224 response:

Through two libraries all_tab_columns table query you want DDL statements, loops,

A great god, and can understand some

Just wrong, it should be a matter of synchronous data, the demand again say clear point, some examples,

So, I now have two databases, for example, A database A and b. A database the two database has A table of the same structure, now I want to contrast the two database table data is consistent, if inconsistent, generates A DDL statement, endures C of table, and such A process, I know there was A table data contrast of pl/SQL operations, but special cases can't use,,, alas

Inconsistent, generate a what kind of statement? A concrete example

Inconsistencies, such as A table is A more than B data, generate the insert statement, if the data is consistent, then update the data, to delete the temporary not consider

With a minus

CodePudding user response:

PLSQL DEVELOPER this kind of tools, has this function, can try,

CodePudding user response:

Your table is the only fixed reference?
You say, 'A table in A database, and database B of A table by comparing,' if A database A table is A reference table unchanged,
You can minus A library and A table B library under A table, the result is A library and A table B library inconsistent data, A table in the table you put B library A corresponding data delete, then put this part of the data is inserted into the library, A table B
Conversely perform again, completes the data consistent

CodePudding user response:

Insert into c values (column1, column2) select a.c olumn1, a.c olumn2... From a where not the exists (select 1 from b where biggest olumn1=a.c olumn1... ) the union
Select (biggest ounmn1, biggest olumn2... ) from b where not the exists (select 1 from the where a biggest olumn1=a.c olumn1... )
Among them exist where biggest olumn1=a.c olumn1... Is that all the columns

CodePudding user response:

https://blog.csdn.net/jhon_03/article/details/78321937

refer to 7th floor nayi_224 response:

Quote: refer to the sixth floor qq_29895367 response:

nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull