Sorting Data - How Versatile is ORACLE/Sybase?
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Fri, 15 Jul 94 10:17:00 -0500
Message-ID: <12a.3367.905_at_compudata.com>
Date: Fri, 15 Jul 94 10:17:00 -0500
Message-ID: <12a.3367.905_at_compudata.com>
Oracle doesn't have a "sort" function. What it does have is the
order by
clause which allows you to determine the order of rows returned from a
query. This can be helped along by creating indexes on the fields which
you typically use in the order by.
BUT: You cannot have multiple type of sorts, such as some straight ascii and others dictionary. You have to choose what type of sorting you will do on DB startup (defaults to straight ASCII on my system).
I get around this by occasionally creating tables that are all the words in a field, uppercased, and then selecting against this table to get back the original record number. Received on Fri Jul 15 1994 - 17:17:00 CEST