Database Star: Home

ORA-00911 invalid character Solution

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

Are you getting an "ORA-00911 invalid character" error when running an SQL statement? Find out what causes it and how to resolve it in this article.

ORA-06512 At Line Solution

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

Share on:

Did you get an ORA-06512 error when running an SQL query? Learn what this error is and how to resolve it in this article.

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

Feb 6, 2017 · 5 min read · sql ·

Share on:

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.