© 2023 Hashnode
#plsql
Quite some time ago I was asked by a customer how we could track the changes to a row over time. They had a couple of very important tables for which they wanted to keep track of who changed what. The…
There are many times when you're coding an application where there is a requirement for seed data that is required for the system to run correctly. If the seed data is changed or missing, some program…
Somewhere around version 9 (maybe before, maybe later…all so long ago 😀) the distinction between CLOB and VARCHAR2 became less defined. This was a good thing because the typical operations you would …
JSON (JavaScript Object Notation) is a lightweight data-interchange format primarily for transferring data between systems. In most cases, we parse the JSON object to store the values in relational ta…
Overview The DBMS_MLE package allows users to execute JavaScript code inside the Oracle Database and exchange data seamlessly between PL/SQL and JavaScript. JavaScript data types are automatically map…
Overview SQL (Structured Query Language) is an ANSI standard adopted in 1986. Many RDBMS (relational database management system) vendors have used it as a foundation. At the same time, PL/ SQL stands…
Some end users have been complaining to me about losing their public and private reports after installing a new version of an application. Somewhere, somehow, the connection between the application an…
I’ve done a lot of talks mainly around the tremendous performance benefits you can get just by employing a little bit of PL/SQL in the core parts of your applications. This advice has been valid for a…
Introduction Continued from part 1 of this series on using incoming webhook to send Slack messages through an APEX application. This new post will focus on covering the missing features that incoming …
How often do I need to generate a password for one of my database users and colleagues? Here is how I do that. function auth_pwgen return varchar2 is l_pos integer; l_pw varchar2(100); l_c varchar2(100) := 'bcdfghjklmnprstvwz'; --c…
