Database Star: Home

Difference Between CHAR, VARCHAR, and VARCHAR2 Data Types in Oracle

Feb 6, 2017 · 5 min read · sql ·

Oracle has several character data types that are commonly used and can also be confusing if you don't know the differences between them. Learn what they are and the differences between them in this article.

ORA-01722 invalid number Solution

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

Share on:

Learn all about the ORA-01722 error in this guide.

How to Resolve ORA-01017 Invalid Username/Password; Logon Denied

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

Share on:

Have you gotten an ORA-01017 error in your Oracle database? Learn what caused it and how you can resolve it in this article.

Oracle SQL List Tables in Database or Schema

Jan 30, 2017 · 3 min read · sql ·

Share on:

Do you need to list all tables in Oracle? There isn't an SQL list tables command, but you can learn how to show all tables in this article.

ORA-00942 table or view does not exist Solution

Jan 27, 2017 · 4 min read · sql-errors ·

Share on:

Have you gotten an ORA-00942 error? I'll explain the cause and the solution of the error in this article.

ORA-00904 invalid identifier Solution

Jan 25, 2017 · 5 min read · sql-errors ·

Share on:

Did you get an "ORA-00904 invalid identifier" error? Find out what caused the ORA-00904 error and how to resolve it in this article.

Oracle Triggers - The Complete Guide

Jan 23, 2017 · 27 min read · sql ·

Share on:

Oracle triggers are a handy but often misused function of the Oracle database. Learn all about them in this article.

What's The Difference Between Oracle ROWNUM vs Oracle ROW_NUMBER?

Jan 16, 2017 · 6 min read · sql ·

Share on:

Have you seen ROWNUM and ROW_NUMBER in Oracle and wondered what the difference is? Learn what they are and the differences between Oracle ROWNUM vs Oracle ROW_NUMBER in this article.

Singular vs Plural and Other Database Table Naming Conventions

Jan 2, 2017 · 11 min read · database-design ·

Share on:

Are you wondering if you should name your SQL database tables in the singular form or plural form? Learn what the preferred convention is and some reasoning behind it, as well as other database table naming conventions, in this article.

Oracle Certification Dumps Can Ruin Your Career

Dec 5, 2016 · 7 min read · sql ·

Share on:

Are you looking to get certified? Want to get your hands on some Oracle certification dumps for an exam to help you pass? That's a bad idea. I'll explain why in this article.