Re: before I re-invent the wheel

From: Andrew Kerber <>
Date: Thu, 13 Jan 2011 08:01:35 -0600
Message-ID: <>

I think that is the last step, or pretty close to it. But I have to read the data from Oracle and write out those sqlplus files also. I am sure I can do it, but was hoping somebody already has something similar. The basics steps are (as I see them):
  1. Read record from the table
  2. Write out .sql file with the command.
  3. Proceed to next record
  4. After all .sql files are generated, run the .sql files

I could probably run each .sql after generating it also, either method would work.

On Thu, Jan 13, 2011 at 3:02 AM, Connor McDonald <>wrote:

> On Thu, Jan 13, 2011 at 11:18 AM, Andrew Kerber <>wrote:
>> Before I write this shell script for myself, I thought I would ask if
>> anyone has done this before. I have a table of SQL queries (single queries)
>> that have to be run against various schemas and instances. The table
>> contains all the information I need to run it, including the destination
>> file for each query, I just have to write the shell script that will read
>> the table, and run the query. I suppose it will actually probably need to
>> generate and call the individual sql files that will be run now that I think
>> about it. Anyway, has anyone written something like this and have a
>> sample? Oracle, Solaris and OEL. I could also run it on the
>> client machine if necessary, which is running windows 7.
>> --
>> Andrew W. Kerber
>> 'If at first you dont succeed, dont take up skydiving.'
> Sorry, am I misinterpreting the question ? Isn't this just standard usage
> of SQL Plus parameters ?
> cat file | while read parm1 parm2 parm3 parm4
> do
> sqlplus blah/blah $parm1 $parm2 $parm3 $parm4
> done
> --
> Connor McDonald
> ===========================
> email:
> web:
> "Semper in excremento, sole profundum qui variat"

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Received on Thu Jan 13 2011 - 08:01:35 CST

Original text of this message