Re: Another report question

"amwi" <amwi_at_yahoo.com> wrote in message news:YH_Fc.4263$dx3.33716_at_newsb.telia.net...
> Thank you Daniel for your input.
> Actually I have done a few things on my own, but i am still very new to
SQL
> plus. I only asked for help on the static part of the text. The SQL part
is
> not a problem. I guess you feel at your peak when you can write this kind
of
> remarks... You are probably even an expert on it!
>
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1088972823.32471_at_yasure...
> > amwi wrote:
> >
> > > Sorry, but i really need some help to get started. I know this should
be
> > > simple and very basic but i simply don't know how to get started,
sorry.
> > >
> > > I am using SQL *Plus.
> > > I have started to write on the .sql file that i will execute from SQL
> *plus.
> > >
> > > Now to my problem: I am trying to write a report that generates an
> output
> > > that looks something like this:
> > >
> > > -------------------------------
> > > Report
> > > ===============
> > > Mr xx rented yy movies.
> > >
> > > movie 1
> > > movie 2
> > > ...
> > >
> > > zz rows.
> > > -------------------------------
> > >
> > > Where xx is a name, yy is a count of movies and zz is a count of rows
> > >
> > > Can you please give some coding examples to write out the "static"
text
> > > above?
> > > The "dynamic" parts (sql statements) i can figure out myself, but how
do
> i
> > > insert it into the "static" parts?
> > >
> > > Thank you.
> >
> > Others may feel differently about your requests but my take from what
> > you have posted is that you are either in school and want want someone
> > to do your homework for you or at work and are not able to do the job
> > you are paid to do.
> >
> > Either way I've seen not a bit of evidence of you doing anything to help
> > yourself ... so I'm done with trying to help you.
> >
> > Post what you have written and I will give you hints. Post another
> > request indicating you haven't done a thing and you will be ignored.
> >
> > --
> > Daniel Morgan
> > http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> > http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> > damorgan_at_x.washington.edu
> > (replace 'x' with a 'u' to reply)
> >
>
>

You still havent posted what you have done, post your efforts so far and lets take a look Received on Sun Jul 04 2004 - 17:58:17 CDT