Re: Resources for SQLPLUS & reporting

It might help if you explained the problem. After 6 months of use, you should know sql*plus pretty well.

I assume you've figured out that the first sql needs a semi-colon after it, but the 2nd will be executed by the slash at the end of the script. Ttitle may not change, or change "too soon" depending on page breaks. You could generate a page break by selecting chr(12) from dual.

<billmil_at_my-deja.com> wrote in message news:8ra8gk$mdo$1_at_nnrp1.deja.com...
> Can anyone recommend tips-and-techniques resources for using sqlplus to
> generate reports? I use the manuals (user's guide and reference), but
> would like some "notes from the real world" resources.
>
> I've been using sqlplus for over six months and use it to generate
> reports e-mailed out daily to our admin users. I still haven't figured
> out, however, it's many nuances and limitations.
>
> (For example: right now I'm trying to generate one file which lists the
> results of two separate sql statements--first one, then the other. I
> tried using the TTTILE command between the two sql statements, to
> clearly delineate between the two statements. The results don't match
> my expectations.
>
> Any suggestions?
>
> thanks in advance.
>
>
>
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 02 2000 - 21:38:59 CEST