Monday, October 20, 2014

Recent Posts

The Oracle WITH clause

The Oracle WITH Clause

During my many years working with Oracle SQL, I have seen well written SQL queries from Oracle developers, as well as from Business Analysts. One thing I have seen a lack of (even among experienced Oracle SQL developers), is the use of the Oracle WITH clause. In this post I am going to give you an explanation on how to ... Read More »

Oracle Multiple Replace Function

Oracle Multiple Replace Function

Have you ever been in a situation where you have wanted to have replace several parts of a string into several other strings? In this tutorial I am going to show how to create a multiple replace function. Read More »

Find String Between Start String and End String

Find string between two strings

I work a lot with strings in PL/SQL, and recently I was working on a piece where I called a web service that returned information about longitude and latitude. In this post I will show you how I, in PL/SQL, created a function that returns any string between a given start string, and an end string. Read More »

SQL