Database Star: Home

ORA-12154 TNS Connection Identifier Solution

Mar 15, 2017 · 4 min read · sql-errors ·

Have you gotten an "ORA-12154 TNS could not resolve the connect identifier specified" error? Learn what causes it and how to resolve it in this article.

The Difference Between WHERE and HAVING Clause

Mar 13, 2017 · 4 min read · sql ·

Share on:

What is the difference between WHERE and HAVING clause in SQL? Learn what they are and the differences in this article.

ORA-01031 insufficient privileges Solution

Mar 10, 2017 · 4 min read · sql-errors ·

Share on:

Are you getting the "ORA-01031 insufficient privileges" error? Learn what causes this error and how to resolve it in this article.

ORA-00937: not a single-group group function Solution

Mar 8, 2017 · 3 min read · sql-errors ·

Share on:

Have you received an ORA-00937 not a single-group group function error? Learn what it is and how to fix it in this article.

69 SQL Interview Questions and Answers (Including Interview Tips)

Mar 6, 2017 · 25 min read · job-search sql ·

Share on:

In this guide, you'll see a range of SQL interview questions and answers.

ORA-00907: missing right parenthesis Solution

Mar 3, 2017 · 3 min read · sql-errors ·

Share on:

Did you get an ORA-00907 missing right parenthesis error? Learn what caused it and how to resolve it in this article.

ORA-06502 PLSQL numeric or value error Solution

Mar 1, 2017 · 8 min read · sql-errors ·

Share on:

Are you getting an ORA-06502 error message when working with Oracle SQL? Learn how to resolve it and what causes it in this article.

ORA-06550 line N column N Solution

Feb 24, 2017 · 2 min read · sql-errors ·

Share on:

Are you getting the ORA-06550 error when running an SQL statement? Learn the cause of this error and the solution in this article.

How To Resolve ORA-00933 SQL Command Not Properly Ended

Feb 22, 2017 · 4 min read · sql-errors ·

Share on:

Are you getting the ORA-00933: SQL command not properly ended error? Learn what causes it and how to resolve it in this article. ORA-00933: sql command not properly ended This error is caused by an SQL statement with a clause that is not allowed for that statement. Some examples that might cause this error are: An …

ORA-00936: missing expression Solution

Feb 15, 2017 · 3 min read · sql-errors ·

Share on:

Did you get an ORA-00936: missing expression error? Learn what it means and how to resolve it in this article. ORA-00936 Cause The error you've gotten is this: 1ORA-00936: missing expression Oracle's official "cause and action" that appears along with the error is: 1Cause: A required part of a clause or expression has …