Formatting SQL Code Blocks in Markdown Files
This post was originally published on this siteIntroduction Everything Changes. Our Trivadis SQL & PL/SQL Coding Guidelines are no exceptions. We plan to change rule #1 of our coding styles. From “Keywords are written uppercase, names are written in lowercase.” to “Keywords and names are…
Last Week in Stream Data Integration & Stream Analytics – 24.8.2020
This post was originally published on this siteThis is the 200th edition of my blog series blog series around Stream Data Integration and Stream Analytics! Hurray, today is the 200th edition of my blog series When I started my series years ago I was not…
Last Week in Stream Data Integration & Stream Analytics – 17.8.2020
This post was originally published on this siteThis is the 199th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations from…
Always Free Autonomous JSON Database?
This post was originally published on this siteIntroduction Oracle just released the Autonomous JSON Database (AJD). This is a special version of the Autonomous Transaction Processing (ATP) database focussing on managing JSON documents via Simple Oracle Document Access (SODA) and SQL. Beda Hammerschmidt shows in…
Data Guard, Easy Connect and the Observer for multiple configurations
This post was originally published on this siteEZConnect One of the challenges of automation in bin Oracle Environments is dealing with tnsnames.ora files. These files might grow big and are sometimes hard to distribute/maintain properly. The worst is when manual modifications are needed: manual operations,…
Script to check Data Guard status from SQL
This post was originally published on this siteIn a previous blog post I have explained how to get the basic configuration from x$drc and display something like: OBJECT_ID DATABASE INTENDED_STATE CONNECT_STRING ENABLED ROLE RECEIVE_FROM SHIP_TO FSFOVALIDITY STATUS ——— ————– —————– —————————- ——- ——– ———— ————–…
Last Week in Stream Data Integration & Stream Analytics – 10.8.2020
This post was originally published on this siteThis is the 198th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations from…
Formatting SQL Scripts in a Directory Tree with SQLcl
This post was originally published on this siteIntroduction Oracle’s SQL Developer can format code in any worksheet and PL/SQL editor. The formatter is highly configurable and the default formatting results are becoming better with every version. Oracle’s SQLcl is a command-line tool. It’s a stripped…
Last Week in Stream Data Integration & Stream Analytics – 31.7.2020
This post was originally published on this siteThis is the 197th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations from…
Social Media @trivadis