[raf]

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...ar ea_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

[RastogiKamesh]

Hi,
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.

Hope it helps u. Thanks.

Regards,

[raf]

I haven't written yet my sql code.
I'd like to know how can I create this report (trigger?, procedure?) and after schedule the job.
However I haven't discoverer desktop tool of Oracle9iDS.

Is this the only way to create a update file?

Thanks
Raf