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)
>
Received on Sun Jul 04 2004 - 16:32:40 CDT
