DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SQL*Report Very Urgent

  1. #1
    Join Date
    Jul 2001
    Posts
    334
    Hi,
    Can anyone explain what is a SQL*Report?

    Appreciate for this help
    Thanks

  2. #2
    Join Date
    Jun 2001
    Location
    NJ
    Posts
    118
    Aph,
    If i am correct, earlier version of Oracle reports are called as SQL reports. Same with Forms.

    Thanks

    GD_1976.

  3. #3
    Join Date
    Jul 2001
    Posts
    334
    Hi gd_1976,

    Actually can you go in more detail and explain little more?

    Thanks
    aph

  4. #4
    Join Date
    Oct 2001
    Posts
    3
    APH,

    A very brief history of Oracle's report writing tools (latest first):
    Oracle Reports (v6i, v6, v3, v2.5, v2)
    SQL*ReportWriter (v1.1, v1.0)
    SQL*Report
    (before this I don't know - maybe nothing?)

    SQL*ReportWriter was newish when I first started working with Oracle products, almost 12 years ago. I think SQL*Report was desupported not long after that, although I wasn't using it at the time, so that wasn't important to me (I never used it much anyway).

    An .rpt file was the "report design" for SQL*Report as per the .rdf for Reports Developer, but it was a text file that was edited directly - there was no design tool. The .rpt file was basically a command file allowing some sort of "procedural" processing of data with commands for writing output to files (SQL*Report a "language" unto itself - each command starting with a ".").

    This is a very high level overview of SQL*Report, based on some fairly vague memories.

    As a note - despite the similarity in names, SQL*Report and SQL*ReportWriter were completely different products. There was no automated upgrade path (SQL*Report provided a lot of procedural functionality that was not avaliable in SQL*ReportWriter - which was basically a MUCH simpler version of the current Oracle Reports without PL/SQL). I vaguely remember a 3rd party utility that converted SQL*Report .rpt files to Pro*C, but not much more than that.

    I hope that this helps, but I don't know what sort of answers you were looking/hoping for.

    Thanks,

    twinn

  5. #5
    Join Date
    Jul 2001
    Posts
    334
    Hi Twinn,
    Thank you so much for this detail explanation.

    aph

Posting Permissions

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


Click Here to Expand Forum to Full Width