SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Materialized view for WTD, MTD, YTD summary

114620Sep 4 2003

I have a daily table that needs to be summarized into a yearly table containing WTD, MTD and YTD revenue totals.

assume the daily table is :-

Daily_Sales (sale_day date, sales_revenue number(9,2))

Does anyone have the code to create a materialized view for this table or just the SQL query.

i.e. Yearly_Sales(Year, wtd_sales, mtd_sales, ytd_sales)

Thanks,

Mitool

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2003

Added on Sep 4 2003

0 comments

291 views