Re: SQL*Plus Command File questions
Date: 1997/02/24
Message-ID: <19970224163601.LAA06724_at_ladder02.news.aol.com>#1/1
[Quoted] A quick way of introducing the conditional execution is to add the
prompted variable to the where clause for the subseqent selects
eg
prompt &&Continue
select value
from table
where .....
and upper('&&Continue') = 'Y'
/
Subject: SQL*Plus Command File questions From: gennick_at_worldnet.att.net (Jonathan G Gennick) Date: Mon, 24 Feb 1997 15:52:05 GMT
Message-ID: <3311b294.5819084_at_netnews.worldnet.att.net>
My environment is Oracle 7.2 and Win 3.11. I am executing a SQL*Plus command file that selects a few records of data for a user to see, and which then prompts the user for confirmation about proceeding.
When I execute the select statement, SQL*Plus displays a dialogue box titled "Working" with the text "Query is executing...". This is a bit annoying. Is there any way to suppress this? Strangely this dialogue also pops up very briefly when I execute PRINT commands from SQL*Plus.
What is a good way to conditionally execute a command file, or part of a command file. After I prompt the user for confirmation of his intent to continue, I need a way to stop if he says "no".
Thanks,
Jonathan Received on Mon Feb 24 1997 - 00:00:00 CET