Re: How to handle varchar(4000) field containing carriage returns in reporting?

Sameer schreef:
> Hello,
> I am having a Oracle database, the data in tables of which is being
> stored using a web application. One of the fields of a table is having
> varchar(4000) datatype.
> The data in this field is text which may contain carriage returns also.
> I have to create a report for this table. How to display this data
> properly in a report?
> I tried few things:
> Accessed the table using SQL Developer and pasted the query output in
> Excel.
> As the text contains carriage returns, it is being spread into one or
> more rows.
> How to handle this?
> What is the proper way to create report for such data?
> Please help.
> -Sameer
>

Select <column_name> from <table_name>

if there are carriage returns, so be it - any manipulation because it "does not look right" is falsification.

Suppose every politician did that - oh wait, they are...

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...