Solved

Oracle Reports create ad hoc reports

Posted on 2014-01-16
4
444 Views
Last Modified: 2014-01-29
Hello.

New to Oracle Reports but have SQL programming experience with other software products.

Other than having run a couple of existing reports in Oracle Reports, I haven't done anything with the product.

I'm wondering if it's possible, and if so how to navigate to it, to write customized SQL in a code window with this product.  Or, if that's not possible, to at least be able to generate customized queries with a graphical interface (selecting fields and entering search criteria, etc.)

My issue at this point is just trying to navigate through the product.  Ideally, I'd like to be able to get to an area in the product where I can view the tables, fields, relationships, etc and then write SQL code or at least generate custom queries.  

My employer has registered me as a super user if that information is of any help to you.

Thanks.
0
Comment
Question by:dbfromnewjersey
  • 2
4 Comments
 

Author Comment

by:dbfromnewjersey
ID: 39788144
will read.
0
 
LVL 34

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 39789204
I've worked with Oracle Reports since the very first version of it.  Yes, it does allow you to use a GUI interface to "view the tables, fields, ... etc and then write SQL code or at least generate custom queries".  If you click: "Data Model", then click the "SQL" button, then "Query Builder", you can do this.

Or, you can "write customized SQL in a code window with this product" and make that the main (or a secondary) query that the report uses.

But no, Oracle Reports certainly does not support end users "creat[ing] ad hoc reports" with this tool.  This is definitely a tool for programmers or developers, not typical end users.

I have never considered Oracle Reports to be user friendly or easy to work with.  Some standard GUI features (like: "drag and drop", "copy and paste", for example) are only partially supported by Oracle Reports, or only in certain areas of the tool, not some of the areas where you might expect them to work.

The best way to work with Oracle Reports *AND* the way to get reports that perform efficiently is to develop database views that do most or all of the joining, filtering, and/or grouping that you want in the report, then write a simple query in the report to select everything from the view.

You may be aware that Oracle Reports is basically an obsolete product.  Oracle doesn't use it anymore in the latest version of their own applications.  They have switched to OBI or OBIEE (Oracle Business Intelligence Enterprise Edition).
0
 

Author Comment

by:dbfromnewjersey
ID: 39817441
Thanks.  Unfortunately, I'm stuck with having to use what my employer has in in place even though as you say, it's obsolete.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now