hello guys, now we can convert any database table to schema oracle user database using SQLIE app
it is not just a converter, but it is also a merging data
The process of SQLIE is to insert the new data and update the old one
ex: if we have three tables admin1.customers, user1.customers and user2.customers with same structures
admin1.customers using user1.customers and user2.customers without repeating the data
let's see how sqlie wants to deal with the data
admin1.customesrs
id, customer-name
1, jack
100, sally
user1.customers
1, Jack Johnson
2, Peter William
user3.customers
100, sally micheal
101, Sarah edward
sqlie wants to insert peter and sara which does not exist in admin1 and wants to update customer_name jack and sally with full name
so the table admin.customer wants to be like this:
admin1.customesrs
id, customer-name
1, Jack Johnson
2, Peter William
100, sally micheal
101, Sarah edward
i wish the example is clear enough to understand the process of sqlie app
http://sqlie.com/download/SQLIE.zip
it is not just a converter, but it is also a merging data
The process of SQLIE is to insert the new data and update the old one
ex: if we have three tables admin1.customers, user1.customers and user2.customers with same structures
admin1.customers using user1.customers and user2.customers without repeating the data
let's see how sqlie wants to deal with the data
admin1.customesrs
id, customer-name
1, jack
100, sally
user1.customers
1, Jack Johnson
2, Peter William
user3.customers
100, sally micheal
101, Sarah edward
sqlie wants to insert peter and sara which does not exist in admin1 and wants to update customer_name jack and sally with full name
so the table admin.customer wants to be like this:
admin1.customesrs
id, customer-name
1, Jack Johnson
2, Peter William
100, sally micheal
101, Sarah edward
i wish the example is clear enough to understand the process of sqlie app
http://sqlie.com/download/SQLIE.zip