#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    3
    Rep Power
    0

    Question Inexpensive query tool


    Hello, can anyone recommend a reasonably priced tool for querying Oracle DBs and creating reports. In particular, I'm looking for something with a GUI that allows for writing and saving queries, formatting the report output, etc.
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    Check my signature for great opensource tools:
    1. TOra (management tool like Toad)
    2. iReport (reporting tool)
    3. Openreports (web based report distribution tool)

    2. and 3. are both based on jasperreports an open, java based, reporting component, and work very well together.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    San Clemente, Ca
    Posts
    3
    Rep Power
    0
    The best that I've found is the QLR Manager. It's a php server based application that allows you to access your data from anywhere with a browser. I use it for MySQL, but it also works with Oracle databases.

    What version of Oracle are you running? It works with Oracle 7 and later.

    ruski
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    3
    Rep Power
    0
    Thanks, pablo and ruski.

    That gives me quiet a few to look over as I get time. At first glance, qlrmanager appears interesting with its non-intimidating interface for some of our less technically inclined folks in our operational areas. I also like the concept of being able to retrieve queries written by others and modify as necessary. Ruski, we just installed Oracle 8.i
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Posts
    15
    Rep Power
    0
    I recommend DreamCoder for Oracle 1.4 y very easy to use and cheap.

    Is very good for generated report for a query and include the query builder.

    URL : http://www.mentattech.com

    Peter
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Manchester, UK
    Posts
    23
    Rep Power
    0
    I am the author of an addin for Excel called SQL*XL. SQL*XL is a great adhoc query tool. It allows you to get the data directly into Excel where you can do your analysis etc.

    Have a look at SQL*XL at www.oraxcel.com

    Gerrit-Jan Linker
    www.oraxcel.com (SQL*XL)

IMN logo majestic logo threadwatch logo seochat tools logo