SqlDbx
You are not logged in.
As well as being able to generate SELECT, INSERT, UPDATE, ... from the Results could you also add MERGE (Oracle format). Occassionally I need to sync two databases and the use of the Merge would make this task much easier.
Offline
MERGE is very generic and flexible statement.
I am not sure how it can be generated in a way to be useful in different scenarios.
Can you provide an example.
Offline
Merge provides the capability to synchronise a table by inserting rows where the primary key does not exist or by updating rows where the primary key does exist. In situations where you cannot easily drop and reload the table due to referential integrity constraints, this provides an easy way to update a table. Example where this would be useful are: 1) where you have reference tables containing valid value lists; and 2) where you have master tables where there are multiple columns that can be maintained.
Example Merge:
merge into REF_TABLE
using (select 1 from DUAL) s
on (REF_ID = 'DEFAULT_VALUE')
when matched then
update set REF_VALUE = 'YES'
when not matched then
insert (REF_ID,REF_VALUE)
values ('DEFAULT_VALUE', 'YES')
Offline