Re: Return character in long fields??

In article <s68.94.2DEB92AE_at_ornl.gov> s68_at_ornl.gov (Steve Stansfield) writes:
>I'm trying to set up an Oracle 7 table to maintain about 100 reports. These
>reports originate as text files with about 5000 characters. I would like to
>have one field for the report name and another as the text of the report. I
>want to develop an application in either ObjectView or Powerbuilder in which
>the user inputs or selects from a list the report name and the contents of the
>report are displayed.
>
>I've set up a table with a 'long' datatype for the text. Using SQL*Loader, it
>appears that the report text got loaded into the field but when I try to
>display the data in ObjectView/Powerbuilder or SQL Plus, It all shows up on
>one line. Is there a way to force a carriage return/line feed?
>

Have you considered adding another column to your table, that represents the line number of the report. Then the text field could be changed to character and you would only store one line of the report in a row. This would allow for quick navigation through the report. Just a thought.

-- 
============================================================================
Michael Sallwasser  | Down one path is utter dispair and hopelessness. Down 
Long Beach CA       | the other is total destruction. Let us choose wisely.
============================================================================