using PL/SQL to sort quarterly results based on a certain year or sales.
529810Sep 11 2006 — edited Sep 11 2006Hello All.
I want to write a script that does the following:
creates a table with 5 columns, one for name and the other 4 to for quarterly results based on a certain years sales. I then want to use PL/SQL to sort the data and then insert it into the newly created table. Can anyone advise me/show me how to do this using scotts tables?
The table I would get this from would have four columns, one with customer_id, one with shipped_date another with order_date and one with total value.
I want to insert the AVG value for each order for each quarter of the year 1990 into the new table but I can't figure out how to use the PL/SQL to do this, after creating the table I am a bit lost. I need to display the average for all customers for each quarter.
TIA