AREA in this view change every day.
I'd like to create one procedures that takes the data from this view , fills a table it and does the difference between the current area (sysdate) and the area of the previous day.
Re: create report (table) for update area automatically
What i understand is that u hv written sql code / procedure for ur task & the type of result u want, And This u r running from SQL-PLUS. Pls. correct me if i do not understand it properly.
So, this thing u can do it by using the discoverer desktop tool of Oracle9iDS. You can schedule the job (i.e. your query) in the night & in the morning you get your result ready and can port directly to xls file. For this, you have to create some business area by using discovere administrator tool and you should have parameter set in oracle database for running the scheduled job.
We hv implemented this feature in our setup & it is working OK. You may hv to look into documentation for more details & setup in ur area.