Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: 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...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

  2. #2
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146

    Re: create report (table) for update area automatically

    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,
    - KR

  3. #3
    Join Date
    Jul 2002
    Posts
    227
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •