SQLPLUS Question
in [Oracle]
|
From: Gerard H. Pille on 18 Jan 2010 03:56 On 17 jan, 17:34, Jeremy <jeremy0...(a)gmail.com> wrote: > In article <hithhv$d1...(a)solani.org>, gogala.mla...(a)gmail.com says...> > > > > > On Sat, 16 Jan 2010 20:24:36 +0000, Jeremy wrote: > > > > In article <hit6ej$ph...(a)solani.org>, gogala.mla...(a)gmail.com says...> > > >> On Sat, 16 Jan 2010 18:37:24 +0000, Jeremy wrote: > > > >> > 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? > > > >> Yes. It's called PL/SQL and is available as of the version 6. > > > > Is that intended to be serious answer? > > > Yes. That is precisely what PL/SQL is intended for: you run SQL and > > follow some logic path depending on the outcome. > > Perhaps I assumed I had conveyed more of my requirements to the post > than I did. > > It's about conditional execution of .sql files - am looking at ways to > automate install/upgrades which cannot be done using PL/SQL. > > -- > jeremy Well, you could simply do a: if [ ... ] then SCRIPT=script_A else SCRIPT=script_B fi print -p "start $SCRIPT"
From: Noons on 18 Jan 2010 05:04 Mladen Gogala wrote,on my timestamp of 18/01/2010 5:15 AM: > On Sun, 17 Jan 2010 19:00:23 +1100, Noons wrote: > > >> Souto. Not Suoto. Unless of course you are from PCWorld or >> Computerworld... > > I humbly apologize. Don't worrt, you wouldn't be the first one! Where's Nial these days anyways? Haven't seen his posts except in oracle-l for a while.
From: gazzag on 18 Jan 2010 06:31 On 18 Jan, 10:04, Noons <wizofo...(a)yahoo.com.au> wrote: > > Don't worrt, you wouldn't be the first one! > Where's Nial these days anyways? Haven't seen > his posts except in oracle-l for a while. I saw Niall at UKOUG last November. He seems well. Sadly, a few beers has clouded my memory. I forget now whether I mentioned c.d.o.s to him or not :) -g
From: Mladen Gogala on 18 Jan 2010 14:58 On Mon, 18 Jan 2010 10:03:18 -0800, joel garry wrote: > Are you spelling _his_ name correctly? :-) He is. -- http://mgogala.byethost5.com
From: Noons on 19 Jan 2010 04:08
joel garry wrote,on my timestamp of 19/01/2010 5:03 AM: > Are you spelling _his_ name correctly? :-) Dunno, jgarr. Did I get yours? Lost track somewhere between the last beer and the first scotch... <g,d&r> |