Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> sql script

sql script

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Tue, 23 Jan 2001 15:54:22 +1100
Message-Id: <10749.127238@fatcity.com>


List,

I am having a problem with a sql script than I am running. What I am trying to achieve is to get the result from this script which would be either T or F without the select statement. I get the result including the select that is being executed. eg

select D2 from job
where Name=upper('dailyman_flag')
/

T

Here is script that I execute

spool flag.sql
set verify off
set echo off
set heading off
set serveroutput off
set feedback off
select 'select D'||cal_day_of_wk|| ' from job_temp where Name=upper(''&1'');' from caldayee
/

spool off
@flag.sql

Is there a way to get just the result of T or F without showing the select statement?
If I execute flag.sql alone it seems to give the answer. but I need to run it in a script Received on Mon Jan 22 2001 - 22:54:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US