Complete IT Professional

Helping Software Developers Get Ahead In Their Careers
Oracle TO_SINGLE_BYTE Function with Examples

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. Purpose of the Oracle TO_SINGLE_BYTE Function The purpose of the TO_SINGLE_BYTE function is to convert a string with...
Oracle NCHR Function with Examples

Oracle NCHR Function with Examples

In this article, I’ll explain what the Oracle NCHR function is and show some examples. Purpose of the Oracle NCHR Function The NCHR function returns a character based on the specified number code in the national character set. It’s very similar to the CHR...
How to Calculate the Mean, Median, and Mode in Oracle

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. What is the Mean, Median, and Mode? Mean, median, and...
Oracle NEW_TIME Function with Examples

Oracle NEW_TIME Function with Examples

In this article, I’ll explain what the NEW_TIME function does and show you some examples. Purpose of the Oracle NEW_TIME Function The NEW_TIME function converts a date from one timezone to another timezone.   Syntax The syntax of the NEW_TIME function is:...
Oracle NANVL Function with Examples

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. Purpose of the Oracle NANVL Function The NANVL function is used to return a different value if the specified value is NaN (not a number)....
Creating a Web App – One Year On

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. One Year On I wrote a post where I decided to create a web app. It’s a customised reporting tool...
Oracle DECOMPOSE Function with Examples

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. Purpose of the Oracle DECOMPOSE Function The DECOMPOSE function is used to transform a string into a Unicode string. It will split a...
How I Organise Email At Work To Keep Track Of It All

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? I used to get that as well. This was until about a year ago when I changed the way I handle my email at work. I’ll explain...
Oracle COMPOSE Function with Examples

Oracle COMPOSE Function with Examples

In this article, I’ll explain what the Oracle COMPOSE function is and show you some examples. Purpose of the Oracle COMPOSE Function The COMPOSE function allows you to provide a string or a string expression, and return a Unicode string of that input. It’s...