Problem in records while getting data from DataBase

[Amareswar]

Hi,
My record is broken when i am attempting to store data from Oracle database to .dat file using script.
Please suggest me regarding this.
will line size parameter in my script effects??

[Warren_9]

set the linesize should be OK.

BTW, how long is your record?

[Indira Aramandla]

Hi

If you are selecting data from a table to be written into a flat file, for
loading or other purposes, and the the flat file which is being created from the
output of the select must have contain only one record per line then you can set the linesize to say 200 like this in your script.

SQL>set linesize 200

IA

[Yogeeraj_1]

hi,
assuming your are using SQLPLUS, you can try the following:

set long 4000
set pagesize 500
set linesize 1000
set arraysize 11
set serveroutput on size 1000000

hope this helps!
regards
yogeeraj