In today's blog, we take a look at getting started with Oracle Database Express, and creating a demo application.

What is normalization? Let's have a look at designing a set of normalized database tables for our demo application.

In today's blog we create a PL/SQL procedure that our demo application will use to log messages.

In this post we look at a handy string function to extract fields from CSV type records, solving the problems of different delimiters, and embedded quotes in fields that are surrounded with quotes.

Today's blog demonstrates a PL/SQL application that imports sales order data from CSV files into the Oracle database. The demo application contains some ready-made PL/SQL packages to handle the process of loading data from CSV format files into staging tables, logging errors, and moving processed files. In the previous blog we looked at a function to extract individual fields from CSV records, and we will use this for our import process.

In this post, we take a look at a PL/SQL function that exports data from the Oracle Database to a CSV file.

A look at numeric functions in PL/SQL, with examples of code to convert numbers to different bases, alpanumeric strings, calculate factorials.

Here we look at some useful PL/SQL date functions: finding the date of Easter, and related holidays for any year;