Database Star: Home

How To Resolve ORA-00979 Not a GROUP BY Expression

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

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.

Oracle DUMP Function Explained with Examples

Dec 17, 2015 · 4 min read · sql-functions ·

Share on:

The Oracle DUMP function tells you the data type of an expression. Let's learn how to use it and see some examples in this article.

88 of the Best Programmer Jokes

Nov 30, 2015 · 20 min read · programming ·

Share on:

In this article, I've listed a whole bunch of programmer jokes that only programmers will understand!