Hello
Is it possible to perform a MERGE operation without including a field-list?
By comparison, we can SELECT, DELETE, and INSERT without identifying each field. These are valid Oracle SQL:
SELECT * FROM MyTable;
DELETE FROM MyTable;
INSERT INTO MyTable VALUES ('Jack', 'White');
Can we eliminate the field-list in a MERGE statement? The bold part is what i'd like to remove-- can MERGE match positionally, or match same-named columns?
MERGE INTO dest_tab tt
USING source_tab st
ON (tt.id = st.id)
WHEN MATCHED THEN
UPDATE SET tt.code = st.code,
tt.description = st.description;
The purpose is to avoid listing fieldnames in the query, so that the query can adapt to changed fieldnames (in both tables) without breaking.
thx!