Database Star: Home

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

Jul 25, 2016 · 7 min read · sql ·

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.

How To Resolve ORA-00979 Not a GROUP BY Expression

Jul 11, 2016 · 4 min read · sql-errors ·

Share on:

Have you tried to run a query and got the "ORA-00979 not a group by expression" error? Learn what it is and how to resolve the error in this article.

What is the DUAL Table in Oracle?

Jul 4, 2016 · 4 min read · sql ·

Share on:

Have you seen SQL statements with the word DUAL in them? Wondering what it is? Find out what the dual table in Oracle is in this article.

Oracle SOUNDEX Function with Examples

Jun 30, 2016 · 4 min read · sql-functions ·

Share on:

The Oracle SOUNDEX function is one of the most interesting functions I've used in Oracle. Learn what it is and how it works in this article.

How to Limit the Number of Rows in Oracle SQL After Ordering

Apr 18, 2016 · 5 min read · sql ·

Share on:

In this article, I'll show you how you can limit the number of rows in Oracle SQL.

How to Select Rows with Max Value for a Column in Oracle SQL

Apr 4, 2016 · 7 min read · sql ·

Share on:

A common question in Oracle SQL, and SQL in general, is to select rows that match a maximum value for a column. Let's see how you can do that in SQL.

Oracle SYS_CONTEXT Function with Examples (including Oracle 12C)

Mar 13, 2016 · 10 min read · sql-functions ·

Share on:

The SYS_CONTEXT function is an Oracle function that checks configuration values on the database. Learn how to use it and see some examples in this article.

189 Career Quotes To Motivate and Inspire You

Jan 18, 2016 · 24 min read · work-performance ·

Share on:

This article has a list of career quotes.

Oracle EXTRACT Function Explained with Examples

Dec 31, 2015 · 5 min read · sql-functions ·

Share on:

The Oracle EXTRACT function is very useful when you're doing any work with a date field or date expression. Let's learn what it is and see some examples in this article.