Re: SQLPLUS Question
From: Jeremy <jeremy0505_at_gmail.com>
Date: Sat, 16 Jan 2010 20:30:37 -0000
Message-ID: <MPG.25bc324ca34352179897cc_at_News.Individual.NET>
In article <4b5212b2$0$2864$ba620e4c_at_news.skynet.be>, ghp_at_skynet.be says...>
> Jeremy schreef:
> > Hi, real simple question and one I suspect the answer to which is "no".
> >
> > Can you create sqlplus scripts with "conditions" such that if for
> > example a SQL statement returns a particular value or error condition
> > then path A or path B is followed?
> >
>
> I start sqlplus from a ksh script as a job, send queries to it and read
> the answers. ksh, which is also a full programming language, takes the
> decisions about how to continue.
Date: Sat, 16 Jan 2010 20:30:37 -0000
Message-ID: <MPG.25bc324ca34352179897cc_at_News.Individual.NET>
In article <4b5212b2$0$2864$ba620e4c_at_news.skynet.be>, ghp_at_skynet.be says...>
> Jeremy schreef:
> > Hi, real simple question and one I suspect the answer to which is "no".
> >
> > Can you create sqlplus scripts with "conditions" such that if for
> > example a SQL statement returns a particular value or error condition
> > then path A or path B is followed?
> >
>
> I start sqlplus from a ksh script as a job, send queries to it and read
> the answers. ksh, which is also a full programming language, takes the
> decisions about how to continue.
Would this be through multiple invocations of sqlplus?
-- jeremyReceived on Sat Jan 16 2010 - 14:30:37 CST