I got saddled with someone's work and I have very little idea on what to do.

Basically, there are X number of .sql files that have to be run with a specific value for the wirecenter. Then, once the sql script is run, the output has to be captured to a csv file. The platform is oracle 8 on a solaris box (don't have version).

So I am supposed to write a script that:

1. Fires off all the .sql scripts.
2. Passes them the value of the wire center which is used to query the DB.
3. Capture the results in a CSV file.
4. Highlight how much time it took the queries to execute.

Anyone want to help me with this?

Thanks!

a sample of the .sql script showing how thhe wire center variable is handled would help.

"A CSV file" - All results are contained in a single file?

Well, those scripts have to be modified by someone.

But here is what I did:

#! /bin/sh

sqlplus -s scott/tiger@DatabaseName << ENDSQL

WHENEVER SQLERROR EXIT 5
WHENEVER OSERROR EXIT 10

SPOOL ${SCI_PORT_OLD.csv}
@create table SCI_PORT_OLD.sql
SPOOL OFF

SPOOL ${CREATE_CLINK.csv}
@Create clink.sql
SPOOL OFF

SPOOL ${FMS_Before_Picture.csv}
@FMS Before Picture.sql "Value_for_Wirecenter"
SPOOL OFF

SPOOL ${Update_FMS_PORT.csv}
@update FMS.SCI_PORT.sql
SPOOL OFF

SPOOL ${FMS_After_Picture.csv}
@FMS After Picture.sql "Value_For_Wirecenter"
SPOOL OFF

SPOOL ${REPORT_FMS_Fallout.csv}
@REPORT_FMS_Fallout.sql "Value_For_Wirecenter"
SPOOL OFF

SPOOL ${REPORT_FMS_NON_CONVERSION.csv}
@REPORT_FMS_Non_Conversion.sql "Value_For_Wirecenter"
SPOOL OFF

SPOOL ${DROP_VANC_CLINK.csv}
@DROP VANCOUVER_CLINK.sql
SPOOL OFF

EXIT;
ENDSQL

What do you think?