My target is to provide sample ETL data flow in PL/SQL, to do that, I need to generate sample data. Basically, I will operate on two data sources: 1) orders data and 2) contact form data:

I received business task to prepare orders/sales report:

• Business requirement is, to be able, to show how much we sale from WWW source, in terms of new clients
• Technical requirements are:
  1. To connect: contact_form table, with orders table, by a algorithm:
     • join by email address
     • deduplica...