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

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

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. What Is Oracle ROWNUM? You might think that ROWNUM is a function in Oracle. However,...
Announcing “Database Star Academy”

Announcing “Database Star Academy”

All of the online courses I have created used to be on a separate site of mine called Software Developer Academy. These have now all been moved to a new section under my main site, called Database Star Academy. Read on to find out more. What Is Database Star Academy?...
Oracle TO_MULTI_BYTE Function with Examples

Oracle TO_MULTI_BYTE Function with Examples

In this article, I’ll be covering the Oracle TO_MULTI_BYTE function, and look at some examples. Purpose of the Oracle TO_MULTI_BYTE Function The TO_MULTI_BYTE function is used to convert a character string from single-byte characters to multi-byte characters....
Oracle COVAR_POP Function with Examples

Oracle COVAR_POP Function with Examples

In this article, I’ll explain what the COVAR_POP function does and show you some examples. Purpose of the Oracle COVAR_POP Function The Oracle COVAR_POP function calculates the population covariance of a set of number pairs. What is a “population...
What are the Differences Between a Primary Key vs Foreign Key?

What are the Differences Between a Primary Key vs Foreign Key?

I explain what a primary key and foreign key is, as well as the differences between primary key vs foreign key in this article. What Is a Primary Key? What is the primary key definition?  A primary key is one or more columns in a table that are used to uniquely...
Oracle COVAR_SAMP Function with Examples

Oracle COVAR_SAMP Function with Examples

In this article, I’ll explain what the Oracle COVAR_SAMP function does and show you some examples. Purpose of the Oracle COVAR_SAMP Function This function returns the covariance of a set of number pairs. What does that mean? Here’s an explanation of what a...
Oracle VSIZE Function with Examples

Oracle VSIZE Function with Examples

In this article, I’ll explain what the Oracle VSIZE function does and show you some examples. Purpose of the Oracle VSIZE Function The VSIZE function returns the number of bytes of an expression using the internal representation. That sounds a lot like the...
Singular vs Plural and Other Database Table Naming Conventions

Singular vs Plural and Other Database Table Naming Conventions

Are you wondering if you should name your Oracle 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. Why Do We Need SQL Table...
Oracle INSTRB, INSTRC, INSTR2, and INSTR4 Function with Examples

Oracle INSTRB, INSTRC, INSTR2, and INSTR4 Function with Examples

In this article, I’ll explain what all of the variations of the INSTR function (INSTRB, INSTRC, INSTR2 and INSTR4) do, and show you some examples Purpose of the Oracle INSTR2, INSTR4, INSTRB, and INSTRC Functions These INSTR functions are variations of the basic...