Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MERGE INTO PAGEEDITCONTROL A
- USING (SELECT
- '1585' AS PAGEID
- ,'admin' AS EDITUSER
- ,sysdate AS EDITDATE
- FROM DUAL) B
- ON (A.PAGEID = B.PAGEID)
- WHEN MATCHED THEN
- UPDATE SET
- A.EDITUSER = B.EDITUSER
- ,A.EDITDATE = B.EDITDATE
- WHEN NOT MATCHED THEN
- INSERT (
- A.PAGEID
- ,A.EDITUSER
- ,A.EDITDATE
- )VALUES(
- B.PAGEID
- ,B.EDITUSER
- ,B.EDITDATE
- )
Add Comment
Please, Sign In to add comment