Re: argh, SQL sucks....stupid quirk...
From: Tony Damon <ardamon_at_srv.PacBell.COM>
Date: 1995/07/07
Message-ID: <3tjn33$jah_at_gw.PacBell.COM>#1/1
Date: 1995/07/07
Message-ID: <3tjn33$jah_at_gw.PacBell.COM>#1/1
> I can't believe the error I just got with SQL*PLUS. I have 2 selects
> one after the other in a script...basically 2 seperate queries, but I
> want them to print out one after the ohter. It wasn't working because
> SQL.PNO would reset after each query (page 1, page2, page 1, etc) so
> I set embedded on. NOW, it has a btitle on a page by itself between
> the queries. The numbers number correctly but the btitle screws up.
Don't define the BTITLE until after the first query, or turn it off by BTITLE OFF, then turn it back on by BTITLE ON (assuming you already defined it) before the second query.
Tony Damon
.
.
Received on Fri Jul 07 1995 - 00:00:00 CEST