How to UPSERT (INSERT or UPDATE) rows with MERGE in Oracle Database

It's awesome! A colleague of mine uses merge for batch jobs, as it is a great deal quicker.

Unfortunately, performance seems to drop when using it to insert/update individual entries.

Upgrading to Angular 9

I've used the guide in [1].

Just writing down my notes on what I encountered.

$ ng version

Angular CLI: 8.3.23
Node: 10.13.0
OS: linux x64
Angular: 8.2.14
... animations, common, compiler, compiler-cli, core, forms
... language-service, platform-browser, platform-browser-dynamic
... router

Package                           Version
-----------------------------------------------------------
@angular-devkit/architect         0.803.23
@angular-devkit/build-angular     0.803.23
@angular-devkit/build-optimizer   0.803.23
@angular-devkit/build-webpack     0.803.23
@angular-devkit/core              8.3.23
@angular-devkit/schematics        8.3.23
@angular/cli                      8.3.23
@ngtools/webpack                  8.3.23
@schematics/angular               8.3.23
@schematics/update                0.803.23
rxjs                              6.4.0
typescript                        3.4.5
webpack                           4.39.2

So let's try to update using [2].

Update to the latest 8 version.

ng update @angular/core@8 @angular/cli@8

This upgraded my version of Angular from 8.3.23 to 8.3.26

Update to the 9 version.

ng update @angular/core @angular/cli

This upgraded my version from 8.3.26 (obviously) to 9.1.3 .

Of course, this means it's probably a good idea to upgrade to the lastest libraries I also use.

npm install npm@latest -g

npm upgrade

These are (in no particular order):

• ckeditor (1.1.2 to 1.2.3)
• @ng-bootstrap/ng-bootstrap (5.1.5 to 6.1.0)
• ngx-cookie-service (2.3.0 to 2.4.0)

I've removed jquery and popper.js, these are no longer necessary as I am using ng-bootstrap.

References

[1] Upgrade Angular 8/7 to Angular 9 With Ng Update & Angular CLI v9

https://www.techiediaries.com/angular/upgrade-angular-8-7-to-angular-9-with-cli-ng-update/

[2] Official Angular Updater Tool on the Web

https://update.angular.io/

Upgrading Fedora Core

There's an article [1] here. I thought I'd bookmark it, for easy reference.

Reference

[1] Fedora Magazine - Upgrading Fedora 31 to Fedora 32

https://fedoramagazine.org/upgrading-fedora-31-to-fedora-32/