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...