Oracle SQL Indexes – The Definitive Guide

Oracle SQL Indexes – The Definitive Guide

Indexes in SQL are an important part of the language. But why is that? What is an Oracle index? And why should you know about them? I’ll cover all of that in this guide. I’ll also show you the different types of indexes, and share many different sites that have... Read more
How to Escape Single Quotes in SQL

How to Escape Single Quotes in SQL

Do you need to escape special characters or escape a single quote in SQL? Learn how to do that in this article. What Is Escaping? When you are working with text values in Oracle SQL, you use single quote characters. This could be when you’re selecting them:... Read more
What Is a Self Join?

What Is a Self Join?

A self join is a common solution to a specific table design in databases. Learn what a self join is and how to write queries against it in this article. What Is a Self Join? A self join is a type of join in a database where you join a table to itself. It’s... Read more
Oracle SQL IF Statement

Oracle SQL IF Statement

Do you want to write an SQL IF statement? Learn how to do that in Oracle in this article. What’s an IF Statement? In case you’re not sure, an IF statement allows you to do something if a condition is true, and something else if the condition is false.... Read more
ORA-20000 Cause and Solution

ORA-20000 Cause and Solution

Have you gotten the ORA-20000 error when working with Oracle PL/SQL? Learn what causes it and how to resolve it in this article. ORA-20000 Cause The ORA-20000 error code is displayed when there is some PL/SQL code that calls RAISE_APPLICATION_ERROR. Also, the code is... Read more