hello all
I desperately need some help with Perl! I am very new to this programming language, never practiced it before, however where I work I have to write a program that does the following:

There are two very large databases one is done on Oracle, the other in SQL server. The overall aim is to report the differences of certain fields in the databases. They are both meant to contain similar (if not) the same information but ofcourse the field names may not necessarily be written in the exact same words. The idea later on is to use this kind of report to possibly synchronize the databases, but that is well down the track. Currently, the only thing that is required is to report the differences on a small number of fields (5 of them). The report generation is to be done automatically and to be put in an output file preferably and excel spreadsheet or text file. This is then to be emailed automatically to the appropriate team... At this stage I have worked out the SQL statement that is to be used to extract this information from both databases, also how to connect to both the database, but in order to write a program like this, where do i start? what do i incorporate? what are the main things to consider? And in what order? I am very lost.. pls help! Thanks

In reply to Generating reports from Databases by vic07

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.