I have the following queries where I am updating values only if they ... You could try: UPDATE test SET test1 = NVL(test1, 'hello'), test2 ...
www.google.com.tw