Do Not Format Invalid Code in SQL Developer
This post was originally published on this siteIntroduction What happens when you call the formatter in SQL Developer for invalid code? Until recently SQL Developer tried to format it anyway. This produced strange results in some cases. Starting with SQL Developer version 21.2.0 there is…
Last Week in Stream Data Integration & Stream Analytics – 24.8.2021
This post was originally published on this siteThis is the 230th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As usual, find below the new blog articles, presentations, videos and software releases from last week. Happy reading and stay…
Oracle 21c: “Open – and more”- Neue Automatismen rund um die PDBs
This post was originally published on this siteMit neuen Datenbank-Version Oracle 21c ist die mit 12c eingeführte Container-Datenbank-Architektur (“Multitenant-Architektur”) bekanntermaßen die einzige verfügbare Architektur. Erfreulicherweise hat Oracle mit 21 einige hilfreiche Automatismen rund um den Upgrade und die Migration von Pluggable Datenbanken eingeführt. TL; DR:…
Last Week in Stream Data Integration & Stream Analytics – 11.8.2021
This post was originally published on this siteThis is the 229th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As my blog is usually quite Kafka-centric, there is something I would like to especially point out this week: the…
Last Week in Stream Data Integration & Stream Analytics – 3.8.2021
This post was originally published on this siteThis is the 228th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As usual, find below the new blog articles, presentations, videos and software releases from last week. Happy reading and stay…
Gold Image mit Release Update 19.12
This post was originally published on this siteSeit Oracle 18c kann man sich von einer Oracle RDBMS-Software-Installation ein eigenes Image erzeugen und für spätere Installationen nutzen. Damit kann sich sein Paket mit allen notwendigen Patches zusammenstellen und spart sich so einiges an Aufwand bei späteren…
Release Update 19.12 (Juli 2021) – Erste Erfahrungen
This post was originally published on this siteSeit Freitag, 23. Juli, ist der Release Update 19.12 für Linux 64-bit-Systeme verfügbar. Grund genug, über das Wochenende mal das komplette Lab zu patchen. Hier meine ersten Erfahrungen rund um die Installation des Patches. Single-Instance-System Auf meinem Single-Instance-System…
Oracle Critical Patch Update Juli 2021 – der Statistik-Post
This post was originally published on this siteHeute ist der quartalsmäßige Patch-Tag bei Oracle. Jedes Quartal, “an dem Dienstag, der dem 17. des Monats (Januar, April, Juli bzw. Oktober) am nächsten liegt, veröffentlicht Oracle Patches für sein Produktportfolio. Dieses Mal sind es insgesamt 342 Patches…
Lightweight Formatter for PL/SQL & SQL
This post was originally published on this siteTL;DR Bye bye heavyweight formatter. Long live the lightweight formatter. Are you using Oracle’s SQL Developer or SQLcl? Then install these settings and press Ctrl-F7 to produce code that conforms to the Trivadis PL/SQL & SQL Coding Style….
Social Media @trivadis