Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select output format

Status
Not open for further replies.

inexperienced1

IS-IT--Management
Aug 9, 2002
49
US
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
 
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

 
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:
Code:
set colsep ''
Let us know your findings/results.


[santa]Mufasa
(aka Dave of Sandy, Utah, USA)

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
 
Thanks but set colsep doesn't exist in this version of Oracle RDB.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top