Unanswered: need help with populating table using insert and select
I have a data warehouse fact table that I need to re-populate using an insert and select sum(column) query: below is the query that I am trying to use but it fails. We have Oracle 8i database on Solaris. Can anyone help me out?
INSERT INTO fact_tb1
WHERE week_id between 1 and 52
GROUP BY week_id