Shell Programming and Scripting

Hi all I am new to unix . I need to write a script that extracts some data from oracle into a .csv file with heading of the columns in the file

SO i created the following two scripts but they are not working

ac.sql (this is the sql file that i will call inside the shell script when i run these commands one after one and not in a script then it runs but it doesnt give me the name of the columns in the output file
)
set head off pages 0
set feedback off
SET NEWPAGE 0
SET SPACE 0
SET ECHO OFF
SET FEEDBACK OFF
SET TERM OFF
SET PAGESIZE 0
SET LINESIZE 32767
SET TRIMS ON
set verify off
set colsep ','
column c1 heading "Activitylogid" Format 99999999
column c2 heading "category" Format A50
column c3 heading "type" Format A50

spool sample.csv

select activity_log_id c1, activity_category c2,activity_type c3 from activitylog where rownum<100;

spool off

ab.sh ( this is the actual shell script when i run this it hangs )
#!/bin/sh

sqlplus -s user/pwd@ORCL@ac.sql
/
exit
eof

please suggest how to do it ... i have used .sql file because i want to suppress the sqlcommands in the output file

Remove that "-s" and run your shell script and you'll know why it "hangs", or what exactly is going on.

It doesn't show the column headers because you either set heading off or pagesize 0 or both.

tyler_durden