QR Codes Generator package provides functionality to quickly and efficiently generate QR Codes (module 2) directly from Oracle database. It requires no additional ...

Oracle Database 23ai is the next long-term support release and offers over 300 new features. Originally named Oracle Database 23i, it was rebranded to Oracle Database 23ai with a heavy focus on ...

Last time, I showed how functions may be called an unnecessary number of times when used in the WHERE part of a query. Not only was the function called when a simple and direct condition could already ...

We often have to use functions within SQL queries in order to restrict data. What we often do not see is that the functions may be called way more than needed. Here is an example. create table header ...

Timilehin is a skilled software engineer and technical writer with an undying passion for building secure and scalable server-side systems with Go, Node.js, C++ and AWS. Timilehin has worked ...

SVG Images Generator PL/SQL package provides functionality to quickly and efficiently generate SVG images directly from the Oracle database. It requires no additional resources and it is developed in ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

Reuven reviews the latest and most interesting features in PostgreSQL 10. PostgreSQL has long claimed to be the most advanced open-source relational database. For those of us who have been using it ...

The three most common open source technologies for writing data science programs are Python, SciLab, and R. Here's how to write program-defined functions in R. There's no clear definition of the term ...

Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability ...