 | |
SQLPLUS Question
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: SQLPLUS Question -
01-17-2010
, 02:00 AM
|
Nial Litchfield or Nuno Suoto as judges in this matter. |
<g,d&r>
#22
| |||
| |||
|
|
On Sat, 16 Jan 2010 20:24:36 +0000, Jeremy wrote: In article <hit6ej$phc$4 (AT) solani (DOT) org>, gogala.mladen (AT) gmail (DOT) 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. |
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
#23
| |||
| |||
|
|
Souto. Not Suoto. Unless of course you are from PCWorld or Computerworld... |
--
http://mgogala.byethost5.com
#24
| |||
| |||
|
|
In article <hithhv$d1... (AT) solani (DOT) org>, gogala.mla... (AT) gmail (DOT) com says... On Sat, 16 Jan 2010 20:24:36 +0000, Jeremy wrote: In article <hit6ej$ph... (AT) solani (DOT) org>, gogala.mla... (AT) gmail (DOT) 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 |
if [ ... ]
then
SCRIPT=script_A
else
SCRIPT=script_B
fi
print -p "start $SCRIPT"
#25
| |||
| |||
|
|
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. |
Where's Nial these days anyways? Haven't seen
his posts except in oracle-l for a while.
#26
| |||
| |||
|
|
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. |
beers has clouded my memory. I forget now whether I mentioned c.d.o.s
to him or not
-g
#27
| |||
| |||
|
|
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. |
jg
--
@home.com is bogus.
These folks were in their big psychedelic bus in the Xmas parade:
http://www.signonsandiego.com/news/2...ult-depiction/
http://photos1.blogger.com/blogger/6...lveTribes1.jpg
http://2.bp.blogspot.com/_B6gyINLrSB...lveTribes2.jpg
#28
| |||
| |||
|
|
Are you spelling _his_ name correctly? :-) |
--
http://mgogala.byethost5.com
#29
| |||
| |||
|
|
Are you spelling _his_ name correctly? :-) |
Lost track somewhere between the last beer
and the first scotch...
<g,d&r>
#30
| |||
| |||
|
|
On Mon, 18 Jan 2010 10:03:18 -0800, joel garry wrote: Are you spelling _his_ name correctly? *:-) He is. --http://mgogala.byethost5.com |
http://groups.google.co.uk/group/com...rch+this+group
HTH
-g
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.