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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Running select queries only in my script

Re: Running select queries only in my script

From: <redrobot5050_at_gmail.com>
Date: 15 Dec 2005 11:52:41 -0800
Message-ID: <1134676360.939354.117260@g14g2000cwa.googlegroups.com>


Hari,

Perhaps in your script, you could define a variable and assign it a value of true or false.
Then, wrap the section of code that you want to conditionally execute around a IF statement.
So insted of :
/*
code that you don't want to run sometimes */

you could have a script with a var
bExecSelects := false
......
IF (bExecSelects) THEN
  code that you don't want to run sometimes END IF; Received on Thu Dec 15 2005 - 13:52:41 CST

Original text of this message

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