Need help in Setting the Linesize

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Need help in Setting the Linesize

Author

Topic

sanket80
Starting Member

2 Posts

Posted - 2006-12-13 : 14:57:00

Hi,
When I run a sql query, the output of 2nd and 3rd column wraps with each other. There are 3 columns in the output and the problem comes with 2nd and 3rd column . The second colum is a Numeric Field and the 3rd column is a date field.
Below is what I use before running the query
---------------------------------
SET LINES 10000
SET LINESIZE 60
SET PAGESIZE 20000
SET SPACE 0
SET FEEDBACK OFF
COLUMN ABCDEF FORMAT A15
COLUMN AB_CD_ABCDEFG FORMAT 999999
COLUMN ATTEMPT_TIME FORMAT DATE

and then I hav the SQL....Executing it shows me wrapped output.
I even changed the linesize to 80 but it did not worked.
Can somebody pls help.

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-13 : 15:03:06

Is this ORACLE?

Peter Larsson
Helsingborg, Sweden

sanket80
Starting Member

2 Posts

Posted - 2006-12-13 : 16:33:24

Yes....This is oracle

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-13 : 16:35:50

Well, you have posted your query in a MS SQL Server forum.
I just thought I should tell you since you haven't got any answers yet.

Try www.oraclefaq.com or www.dbforums.com

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources