Search Results

Hi! peolpe

I m stuck again.Can somebody help me out.I need right a script that attaches a csv file to a mail then e-mail it.

I have tried the mailx option but I m not gettin any mail on my...

thanx...I will play around with the select statement and let know.

Thnx for your quick responce...this is what I have

SET TERMOUT OFF
SPOOL /app/oracle/dummy.csv

SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF...

Thanx for your reply...

Do you mean sumthin like diz?

select st.description|| "," ||fr.businessname|| "," ||fr.comments|| "," || fr.customernumber|| "," || fr.progress|| "," ||...

Hi! I can be ble to select data from oracle bd tables.I can spool it to the a csv file.What I need is to format the data in order to put in the column titles.

Any help will be appreciated.

Hi! Thanx

when i run that from PLSQL I get the expected results(data is being pulled from database) but I want to put it from the database to a file.

Any suggestions

Hi! Everyone

I am new to the shell scripting basically.I have been asked to create a shell script that connect to a oracle database to read data from a particular schema then spool it into a csv...