Oracle

How to Convert Data Types in Oracle SQL

May 5, 2015 · 5 min read · sql ·

When using Oracle SQL, there are many ways to convert data types. Three of the most common data types are string (VARCHAR2), number, and date. Let's take a look at how you can convert to these types.

Oracle TRUNC Function Explained with Examples

Mar 26, 2015 · 7 min read · sql-functions ·

Share on:

The TRUNC function is one of the most common and versatile functions in Oracle. Let's take a look at how it's used and some examples.

Oracle CONCAT Function with Examples

Mar 19, 2015 · 6 min read · sql-functions ·

Share on:

The Oracle CONCAT function is not a very widely used function, but still helpful. Learn more about the CONCAT function in this article.

Oracle REPLACE Function Usage, Tips & Examples

Feb 26, 2015 · 9 min read · sql-functions ·

Share on:

The Oracle REPLACE function is another string manipulation function within Oracle. Learn how to use it and some common examples in this article.

Oracle DECODE Function Explained with Examples

Feb 19, 2015 · 10 min read · sql-functions ·

Share on:

The Oracle DECODE function can be confusing to those who have never used it. It's a useful function for comparing values. Learn more about this function and some examples in this article.

Oracle TO_CHAR Function Explained with Examples

Jan 8, 2015 · 6 min read · sql-functions ·

Share on:

In this article and video, I'll explain how to use the TO_CHAR function.

Oracle TO_NUMBER Function Usage, Tips & Examples

Dec 30, 2014 · 7 min read · sql-functions ·

Share on:

The Oracle TO_NUMBER function is one of the most common number manipulation functions in Oracle. In this article and video, I'll explain how to use the TO_NUMBER function. In this article, you'll learn: What the TO_NUMBER function does The syntax and parameters of the TO_NUMBER function Several examples of queries with …