Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in records while getting data from DataBase

Amareswar
Occasional Visitor

Problem in records while getting data from DataBase

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??
3 REPLIES
Warren_9
Honored Contributor

Re: Problem in records while getting data from DataBase


set the linesize should be OK.

BTW, how long is your record?
Indira Aramandla
Honored Contributor

Re: Problem in records while getting data from DataBase

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
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: Problem in records while getting data from DataBase

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)