Re: Sort long

From: Rafal Jank <yankee_at_wp-sa.pl>
Date: Wed, 28 Feb 2001 15:47:20 +0100
Message-ID: <3A9D0F78.6B471AD@wp-sa.pl>

Oliver Huppert wrote:
>
> Hi *.*
>
> I have a problem in sort my resultset by a long-field.
>
> SELECT * FROM ..... ORDER BY <long-field>
>
> doesn't work.
>

You can't order by long field. one possible solution is to create varchar2 field that will contain first up to 4000 characters of the long field and sort by it. R. Received on Wed Feb 28 2001 - 08:47:20 CST