Cartesian product « Table Joins « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table Joins
  3. Cartesian product
1.Use a Cartesian product/virtual table like this:
2.Using AVG in an analytical function: OVER()
3.Cartesian Products in action