The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 03-18-2009
balireddy_77 balireddy_77 is offline
Registered User
  
 

Join Date: Sep 2006
Posts: 31
Thumbs down shell script to run .sql files

hi Friends,

Please help me in writing shell script to run list of sql files.
database is Oracle 9i,
unix os is solaris
Requirement is
1. sql file must take two inputs a)feed id and b)business date
2.shell script must out put .xls or .csvfile as out put without trimming any column name and column value.
result of the sql may return around 60000 records...

please provide sample .sql file ans sample unix shell script.

thanks in advance..
--bali