Untitled

OTN Appreciation Day: Easy Execution Plans

As part of the #ThanksOTN idea on Twitter, my favourite Oracle feature is the ability to easily view and analyse execution plans for queries. Time and time again I’ve needed to see how a query is running, and Oracle databases make it easy to view the execution plan. You can view it in either a text format or a table format (at least in SQL Developer), and it’s even available with a keyboard…

4 Things To Spend Money On for Work

There are many things that your workplace will provide as part of your employment. Notebooks, pens, computer, and a chair. There are some other things that, if you spend money on, they can really improve the quality and efficiency of your work. (more…)

Oracle EMPTY_BLOB Function with Examples

In this article, I’ll explain what the Oracle EMPTY_BLOB function does and show you an example of how to use it. (more…)

Overview of Oracle Character Sets

I’ve been working with databases for a long time, and the topic of character sets took me a while to understand. This article will answer some of the common questions, and questions I had about Oracle character sets and how they relate to the Oracle database. (more…)

Oracle TO_SINGLE_BYTE Function with Examples

The Oracle TO_SINGLE_BYTE function is useful for databases with different character sets. Learn how to use it and see some examples in this article. (more…)

Oracle NCHR Function with Examples

In this article, I’ll explain what the Oracle NCHR function is and show some examples. (more…)

How to Calculate the Mean, Median, and Mode in Oracle

Calculating the mean, median, and mode in Oracle SQL is a task often performed by report developers or anyone else working with SQL. Learn how to calculate these three values from a range of data in this article. (more…)

Oracle NEW_TIME Function with Examples

In this article, I’ll explain what the NEW_TIME function does and show you some examples. (more…)

Oracle NANVL Function with Examples

The Oracle NANVL function is useful when working with number values. Learn what it does and how to use it in this article. (more…)

Creating a Web App – One Year On

One year ago I decided to create a web app for an organisation a friend of mine works with. I’d like to share where it’s at and what I’ve learnt. (more…)

Oracle DECOMPOSE Function with Examples

The DECOMPOSE function is a handy string manipulation function. Learn more about it and find out what it does in this article. (more…)

How I Organise Email At Work To Keep Track Of It All

Email. It can be a mess. Have you ever looked at your inbox at work and seen a massive list of emails, and not know what to do with them? (more…)

Oracle COMPOSE Function with Examples

In this article, I’ll explain what the Oracle COMPOSE function is and show you some examples. (more…)

Why Do Some Companies Have Teams with People from Multiple Contracting Companies?

Do you work for a company that hires contractors? Have you ever wondered why they use several companies instead of just going to one company for all of their work? This happens quite often, so i wanted to explain why it happens. (more…)

Oracle TO_LOB Function with Examples

The TO_LOB function is an Oracle conversion function. Learn what it is and see some examples in this article. (more…)

Oracle LOCALTIMESTAMP Function with Examples

In this article, I’ll explain what the Oracle LOCALTIMESTAMP function does and show some examples. (more…)

What Does Oracle PARTITION BY Do?

Have you ever seen the PARTITION BY keyword used in Oracle queries? If so, do you know what it does and how to use it? Learn about the Oracle PARTITION BY keyword and see some examples in this article. (more…)