Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Another report question
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.
The secret is in the fact that any string not referencing a column will be considered static. Supplement that with the concatenation operator, denoted as || or concat(), and see where you get.
PLEASE remember to post both the effort so far and the version of the database if you want helpful (and civil) answers.
/Hans Received on Sun Jul 04 2004 - 18:58:17 CDT