Re: Removing Lines between Queries

Yeah, that's a good idea, i have used Union all, and you are right it would be good if is use some perl scripts to modify the spacing and other details.

Thanks

Robert Klemme wrote:
> DB_BOY wrote:
> > Hello,
> >
> > I needed to know if there is anyway wherein i can remove a
> > line between 2 Seperate Queries. Eg:
> >
> > select * .......
> >
> > select *....
> >
> > These Queries output is spooled into a file. I need to know how to
> > delete the line which occurs between these 2 Queries. Using some
> > SQL*Plus command
>
> If you want to make it look like a single query did you consider using
> UNION ALL? Other than that I'm sure some simple postprocessing with
> sed, awk, perl, ruby... will do the job.
>
> Kind regards
>
> robert
Received on Thu Jun 22 2006 - 22:26:36 CDT