Re: Insert if exists
Posted by: Macamba .
Date: January 04, 2016 03:52AM

But I think I have found an alternative way to accomplish what I want with

DELETE FROM address WHERE perident = 'jdoe';

INSERT INTO address 
 (perident, street, number, pcode, city, telephone, email, eori, iban )
 ('jdoe', 'Fill in your own address information', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Thanks for the feedback

Options: ReplyQuote

Written By
January 03, 2016 07:50AM
January 03, 2016 12:46PM
January 04, 2016 03:29AM
Re: Insert if exists
January 04, 2016 03:52AM
January 04, 2016 04:39AM
January 18, 2016 05:44PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.