hi,
I've a view "SPACE" with this columns:

COD_ID...........VARCHAR2(32)
NAME.............VARCHAR2(32)
DESCRIPTION......VARCHAR2(64)
AREA.............NUMBER

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.

FOR EXAMPLE:
VIEW SPACE:

COD_ID.......NAME.........DESCRIPTION........AREA.......DATE_TODAY
101..........Jo............room.............1200.........01/07/03
105..........Tom...........building.........1900.........01/07/03


The procedure must create the table "UPD_SPACE":

cod_id..name..description...today....area_old...area_new..diff_area
101.......Jo.....room.......02/07/03...1200......2000.......800
105......Tom....building....02/07/03...1900......2000.......100



Created this table once I would like to put these data in an available file.
Is possible (with a job oracle) insert in automatic these date on a file (xls, doc, access)available every day?


Thanks in advance!

Raf