From: billmil@my-deja.com
Newsgroups: comp.databases.oracle.tools
Subject: Re: Resources for SQLPLUS & reporting
Date: Wed, 04 Oct 2000 14:54:06 GMT
Organization: Deja.com - Before you buy.
Lines: 18
Message-ID: <8rfgaa$vrr$1@nnrp1.deja.com>
References: <8ra8gk$mdo$1@nnrp1.deja.com> <OA5C5.15$b51.128@wdc-read-01.qwest.net> <8rb081$cgj$1@nnrp1.deja.com> <8rf081$hi7$1@porthos.nl.uu.net>
NNTP-Posting-Host: 199.249.167.137
X-Article-Creation-Date: Wed Oct 04 14:54:06 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
X-Http-Proxy: 1.1 x67.deja.com:80 (Squid/1.1.22) for client 199.249.167.137
X-MyDeja-Info: XMYDJUIDbillmil


Thanks Frank.  A basic error.  I misunderstood the function of the
slash and erroneously thought that sqlplus would only process sqlplus
commands (ttitle, spool) followed by a slash.

In article <8rf081$hi7$1@porthos.nl.uu.net>,
  "Frank" <frankbo@interaccess.nl> wrote:
> That would take a while - wouldn't it?
> Your outpis *is* what i expect; a slash runs whatever SQL statement
> is in the buffer. spool does not need to run, so the / after
> your spool command will rerun the statement.
> Same for the new title command - title2 will be displayed
> but the / makes sql1 to be executed again.
> So, you execute statement 1 three times, sql2 two times.
> --


Sent via Deja.com http://www.deja.com/
Before you buy.