How can i use Merge operation in SQL statement of DB adapter in ICS.

Summary

How can i use Merge operation in SQL statement of DB adapter in ICS.

Content

How can i use Merge operation in SQL statement of DB adapter, my use case is to either insert or update the column values on the condition bases.

I am using the following querl in my SQL developer it is working fine there but when i am using in the ICS integration it is showing error on "Not a valid SQL statement":

SQL query

merge into users using dual

on (id='100')

when matched then

update set name = 'mark', age='89'

when not matched then