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.
Here’s a collection of articles I’ve read over the last week that I found interesting. A shorter list than usual, but still some quality articles!
Have you gotten an “ORA-01722 invalid number” error? I’ll explain what this error is and how you can resolve it in this article.
Have you gotten an ORA-01017 error in your Oracle database? Learn what caused it and how you can resolve it in this article.
Do you need to list all tables in Oracle? There isn’t an SQL list tables command, but you can learn how to do show all tables in this article.
Have you gotten an ORA-00942 error? I’ll explain the cause and the solution of the error in this article.
This week I’ve read a few interesting articles on Oracle and I thought I’d share them here.
Oracle triggers are a handy but often misused function of the Oracle database. Learn all about them in this article.
Want To Improve Your Oracle SQL?
Improve your Oracle SQL queries by signing up to my free 10-day Oracle Tips email course.
BONUS: Oracle SQL functions PDF cheat sheet