topic Re: Problem in records while getting data from DataBase in Operating System - HP-UX

Problem in records while getting data from DataBase

Amareswar — Thu, 04 Aug 2005 01:27:46 GMT

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??

Re: Problem in records while getting data from DataBase

Warren_9 — Thu, 04 Aug 2005 01:34:41 GMT

set the linesize should be OK.

BTW, how long is your record?

Re: Problem in records while getting data from DataBase

Indira Aramandla — Thu, 04 Aug 2005 01:43:46 GMT

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

Re: Problem in records while getting data from DataBase

Yogeeraj_1 — Fri, 05 Aug 2005 23:34:17 GMT

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