Database Star: Home

TNSNAMES.ORA File - The Complete Guide

Apr 10, 2017 · 8 min read · sql ·

The TNSNAMES.ORA file is an important file when working with Oracle. Learn all about what it is, its location, and how to create and edit it in this article.

ORA-12514 Cause and Solution

Apr 7, 2017 · 4 min read · sql-errors ·

Share on:

Are you getting an "ORA-12514 TNS listener does not currently know or service requested in connect descriptor" error? Learn what causes it and how to resolve it in this error.

SQL Glossary of Terms

Mar 30, 2017 · 48 min read · sql ·

Share on:

SQL, and database development in general, contains a lot of terms and acronyms. Check out this SQL glossary to help understand them.

ORA-01400: cannot insert null into (string) Solution

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

Share on:

Have you gotten the "ORA-01400 cannot insert null into (string)" error? Learn what causes this and how to resolve it in this article.

ORA-00972 identifier is too long Solution

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

Share on:

Have you gotten an "ORA-00972 identifier is too long" error? Learn what caused it and how to resolve it in this article.

ORA-00001 Unique Constraint Violated Solution

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

Share on:

Have you gotten an "ORA-00001 unique constraint violated" error? Learn what has caused it and how to resolve it in this article.

SQL ORDER BY - The Complete Guide

Mar 20, 2017 · 9 min read · sql ·

Share on:

The SQL ORDER BY clause and functionality is an important part of a SELECT statement. Learn what it does and how to use it in this article.

ORA-00609 and ORA-609 Solution

Mar 17, 2017 · 2 min read · sql-errors ·

Share on:

Have you gotten an ORA-00609 error or ORA-609 error? Learn how to fix it and what the cause is in this article.

ORA-12154 TNS Connection Identifier Solution

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

Share on:

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.