Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Spaces converting to Tabs

Re: Spaces converting to Tabs

From: John Higgins <JH33378_at_deere.com>
Date: Fri, 02 Apr 1999 18:32:39 -0600
Message-ID: <370561A7.66990575@deere.com>


In your SQL*Plus script, place 'SET TABS OFF' in a line prior to selecting the nextval.

Wayne Miner wrote:

> Have a baffling situation.
>
> I'm running Oracle 7.3 on a Sequent Box, dynix operating system.
>
> We invoke sqlplus from a korn shell script, retrieve the nextval from
> a sequence generator, redirect the output to a file and...
>
> then fire up sed and replace all leading spaces with zeros.
>
> Things usually work fine, however (sporadically), if the nextval is a
> 2 digit number (the sequence is defined as a NUMBER 10), the file
> contains a \t character, instead of the 8 leading spaces.
>
> This is causing some major headaches.
> I've verified that it is not terminal emulation.
> I don't see any obvious environment variables being set....
> This happens on at least two of the Sequent Boxes we're running
>
> Any ideas?
>
> Any suggestions sincerely appreciated
>
> Best Regards
>
> Wayne
>
> --
>
> Wayne Miner Speedware Programmer
> aka wayne_at_sonic.net
> Good things: Newfoundland Dogs, Am Flyer trains Bad things: The FDA
Received on Fri Apr 02 1999 - 18:32:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US