Re: Running SQLPlus from command line

On 18.10.2006 23:31 RLN wrote:
> Using SQLPlus from the command line is there a specific command I can
> include in my .SQL file that would place a comma in between each column
> value?

SET COLSEP http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm#1012319

> What about writing "fillers" to the text output that is spooled? Can
> this be done? For example: a "PartNumber" column is 8 digits long.
> If a particular row has nulls or spaces in the PartNumber column, is
> there a way to write eight zeros to simply indicate for that row, no
> part number existed?

What about

SELECT nvl(trim(partnumber), '00000000') FROM theTable;

Thomas

-- 
It's not a RootKit - it's a Sony