ETL Scheduling Development (5)--Connect Database Run database command subroutine

ETL scheduling to read and write data information, you need to connect to the database, the following sub-program through the incoming database connection string and Database command (or SQL) to run the required operations:

#!/usr/bin/bash#created by Lubinsu#2014source ~/.bash_profilevalues= ' sqlplus-s << EOF  set heading off Feedback off pagesize 0 Verify off echo off    whenever SQLERROR exit SQL. SQLCODE ROLLBACK    commit;    Exit EOF ' echo ' ${values} "

The parameters of the parameter are: Database connection string, Database command (or SQL statement)

ETL Scheduling Development (5)--Connect Database Run database command subroutine