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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to insert a space after each Manager Starts.

Re: How to insert a space after each Manager Starts.

From: Ethel Aardvark <bigjobbies_at_hotmail.com>
Date: 1 Jul 2003 04:44:06 -0700
Message-ID: <1a8fec49.0307010344.64968ec5@posting.google.com>


You are probably asking too much of SQL - remember that it is a database querying language not a formatting language.

How about getting your front-end app to take the unformatted data and present it differently?

ETA navinsm2_at_rediffmail.com (Navin) wrote in message news:<5dc7f532.0306302040.575f3f0_at_posting.google.com>...
> hi,
> Guys this not what i want ...
> i do want to run in sql&plus or report or use break command
> i wnat to get the output using normal sql and return into my front end
> ...
> i wnat to return the output using normal sql and return back to my
> front end that asp
> regds,
>
>
> navin
> Jeremy <newspostings_at_hazelweb.co.uk> wrote in message news:<MPG.196a782df32c5cf3989781_at_news.cis.dfn.de>...
> > In article <3722db.0306300833.1104942_at_posting.google.com>,
> > danielroy10junk_at_hotmail.com says...
> > > To display a blank line after each change of manager, use "break on
> > > manager skip 1" before running your report in SQL*Plus. Note that this
> > > eliminates the display of the same manager number when multiple
> > > records have the same manager number. It is only displayed for the
> > > first record.
> > >
> > Seems like we're all agreed on the solution then - that must be 5 or 6
> > virtually identical posts...
> >
> > cheers
Received on Tue Jul 01 2003 - 06:44:06 CDT

Original text of this message

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