Re: Removing Lines between Queries

From: Robert Klemme <bob.news_at_gmx.net>
Date: Thu, 22 Jun 2006 10:51:08 +0200
Message-ID: <4fv3vsF1kq568U1@individual.net>

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 - 03:51:08 CDT