-
create report (table) for update area automatically
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|