Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Reports in 9i (first release)

Re: Reports in 9i (first release)

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 18 Oct 2002 17:04:12 -0700
Message-ID: <2687bb95.0210181604.3cf7ed72@posting.google.com>


Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3DB03D22.F34A65AE_at_exesolutions.com>...
> Enrico Luciano wrote:
>
> > Dear Sirs,
> > I need to write some reports for my university examination. I
> > already have the database, packages etc etc in Oracle 9i (no 2nd
> > edition)... I used PLSQL developer as a tool.
> >
> > Now I need to write some report, menu and queries in Oracle. I
> > must use them under sql*plus, so no html, xml etc .. only scripts and
> > text.
> > I can do it by my own writing all the boring codes, but I'm
> > looking for a report tool than can let me to define my report and then
> > give me the "source code" of them.
> > What can I use?
> >
> > I tried to look for Report stuff on OTN, but I've found that
> > Report work on the AS 2nd edition only.
> >
> > what can I use to do some simple reports? not too powerful..
> > not too complex to use.. Please give me an advice.
> >
> > thanks in advance
> > Enrico
>
> Lets see ... I teach Oracle at the University of Washington and I am
> really trying very hard to give you the best possible advice. Advice I
> would give to one of my own students were they to post a similar message
> here.
>
> How about: "If you want to learn anything you need to do the work in
> SQL*Plus".
>
> There are no short-cuts to education. If you want the education do the
> heavy lifting. If not ... drop the class.
>
> BTW your instructor may be reading your posting too.
>
> Daniel Morgan
> http://www.extension.washington.edu/extinfo/certprog/oad/oad_crs.asp

Here is a hint: Pull up the SQLPlus Manual and look up ttitle, column, break, compute, and the set command. Then go back and read a section or two. You could be writing simple reports in on an hour or two providing you can write some basic SQL queries.

Received on Fri Oct 18 2002 - 19:04:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US