If exists update else insert - Better At Oracle

A frequent occurrence when writing database procedures is to handle a scenario where given a set of fields, for example a new employee record, update the existing employee record if it exists otherwise create it. Often this problem is solved with a select

betteratoracle.com