Database Star: Home

Oracle TO_DATE Function Usage, Tips & Examples

Nov 15, 2016 · 6 min read · sql-functions ·

The Oracle TO_DATE function is one of the most common and useful string manipulation functions in Oracle, but it can be confusing. I'll explain how to use the TO_DATE function in this article.

A Guide to the Oracle Data Types

Oct 24, 2016 · 21 min read · sql ·

Share on:

In this article, I explain what the different data types are in Oracle database and everything you need to know about them.

Overview of Oracle Character Sets

Oct 3, 2016 · 2 min read · sql ·

Share on:

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.

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

Sep 12, 2016 · 7 min read · work-performance ·

Share on:

I explain how I organise my email at work in this article.

What Does SQL PARTITION BY Do?

Aug 29, 2016 · 4 min read · sql ·

Share on:

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

65 Business Jargon Phrases to Stop Using and What To Use Instead

Aug 22, 2016 · 21 min read · work-performance ·

Share on:

Learn a range of business jargon phrases in this article.

Oracle BFILENAME Function Explained with Examples

Aug 11, 2016 · 2 min read · sql-functions ·

Share on:

The Oracle BFILENAME function is a useful file manipulation function. Learn what it is and how to use it in this article.

Oracle 12c New Features for Developers

Aug 1, 2016 · 25 min read · sql ·

Share on:

Oracle 12c is Oracle's latest version of its database engine. Learn about all of the new Oracle 12c new features for developers in this massive guide.

How to Find the Row That Has the Maximum Value for a Column in Oracle

Jul 25, 2016 · 7 min read · sql ·

Share on:

Do you need to find the data for a row that has the maximum value for a specific column in Oracle? Learn how to do it and see some alternative answers in this article.

How Can You Create A Column With AUTO_INCREMENT in Oracle SQL?

Jul 18, 2016 · 4 min read · sql ·

Share on:

If you've used MySQL, you're probably familiar with the AUTO_INCREMENT feature. But it's not available in Oracle. Read this article to find out how you can auto increment a column in Oracle SQL.