Shell Programming and Scripting

Hello all,
I have a script that is fully functional and satisfactory in oracle. I recently started spooling it's output into unix for processing and manipulation. I do have a few problems however: The output of some columns are altered in the unix output:

1) On oracle, the date comes with a timestamp (ie dd-mmm-yyyy hh:mm:ss) while on unix, all I lose the timestamp (just dd-mmm-yy).

Also, in a column that has a value section, the value 0.00 gets rounded up to just 0.

Is there anyway I can preserve the original values? Please assist.

Khoom

I've worked with Oracle for a long time and never seen this. Could you give a short example of what you get in sqlplus and then what is in the spooled file? (you are using spool?)

can you give a sample lines from the script so we can visualize the problem

before beginning of spooling give the desired format to column.
set column columnName Format formatSpecifier

Hello all.

these are the first few lines

sqlplus -s / <<- eof
set lines 200 (Tried removing that, but it didn't help)
spool <fpath/filename>

I have tried a number of oracle formatting options, but all to no effect. I am using KSH and hp-ux. Thanks y'all for all your help

Try changing your query to use the TO_CHAR function on the date column.

Finally sorted it out. I had put in one VITAL formatting line before the <sqlplus /> command.

I however am still having one slight problem:
I keep getting double outputs.

These are the params I am using before my spool statement:


set lines 1000
set verify off
set feedback off
set echo off
set pages 20
set num 25.

cheers