Database Star: Home

Oracle TRUNC Function Explained with Examples

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

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 …

8 Simple Steps For How to Become a Database Administrator

Oct 16, 2014 · 9 min read · career-plan ·

Share on:

Learn how to become a database administrator with the simple steps in this article.

How To Convince Your Employer To Pay For Your Certification

Jul 3, 2014 · 8 min read · career-plan ·

Share on:

Convince your employer to pay for your certification

6 Easy And Actionable Steps On How To Design A Database

Apr 21, 2014 · 9 min read · database-design ·

Share on:

Whether it's for your workplace or home project, learning how to design a database is a valuable skill. Let's take a look at six easy steps on how to design a database.