Re: Sort long

From: Christoph Pfrommer <Christoph.Pfrommer_at_oracle.com>
Date: Tue, 06 Mar 2001 22:40:07 +0100
Message-ID: <3AA55936.34B9CFE1@oracle.com>

Oliver Huppert wrote:

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

According to the Oracle 8.1.7 documantation, LONG columns cannot appear in certain parts of SQL statements:
e.g. WHERE clauses, GROUP BY clauses, ORDER BY clauses...

(Imagine how big an index would grow with LONG entries...) You might created an additional CHAR or VARCHAR2 column in order to store the first relevant bytes of your LONG text. This could provide the basis for an ORDER BY clause.

Best regards, Christoph. Received on Tue Mar 06 2001 - 15:40:07 CST