Select output format

[inexperienced1]

I am usinf a old VMS system using Oracle 7(?) RDB and need some help in formatting a SQL statement

I have a select statement and need to reformat the column seperator. The select currently adds a space to the first character of the select, and I want to remove it so that the output starts at position one.

I know this is possible in other versions of oracle, but cannot remember the command.

Can anyone assist

 

[KenCunningham]

Is it LTRIM you're thinking of?

 

[inexperienced1]

No.

I have formatted everything but the return from the select statement always adds a space into position 1

ie

col1 col2
reply reply
reply reply

I need

col1 col2
reply reply
reply replay

 

[SantaMufasa]

In,

I am puzzled by your assertion that an extra left-side space exists in your output. In any case, if you wish to eliminate the column separator altogether, then you can issue the command:

set colsep ''

Let us know your findings/results.


Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[inexperienced1]

Thanks but set colsep doesn't exist in this version of Oracle RDB.