Xref: alice comp.databases.oracle.tools:34526 Path: alice!news-feed.fnsi.net!newsfeed.icl.net!colt.net!news0.de.colt.net!newscore.gigabell.net!newsfeed.germany.net!newsfeed.tli.de!news.b-1.de.contrib.net!gate.beusen.de!nobody From: Stephan Born Newsgroups: comp.databases.oracle.tools Subject: Re: Decode function Date: Tue, 26 Oct 1999 10:47:57 +0200 Organization: beusen unternehmensgruppe senkel Systeme GmbH Lines: 27 Message-ID: <38156ABD.953BF728@beusen.de> References: <38147ED7.60F1F559@aol.com> Reply-To: stephan.born@beusen.de Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.5 [de] (WinNT; I) X-Accept-Language: de,en > What if the decode fuction need to be used with list of values using > between > operator? > like say > select ... > from ... > where ... > order by decode(ITF.ITEM_TYPE, (between 60 and 64) , 0, (between 30 and > 32) , 1, 45, > 2, 90, 3, 46, 4, 5); > > Any feedback is appreciated.. > Try to use a table for mapping your values to 'order by'-values. I wrote you that in Thread 'SQL problem with Order by'. Regards, Stephan -- --------------------------------------------------------------- Dipl.-Inf. (FH) Stephan Born | beusen Consulting GmbH fon: +49 30 549932-17 | Landsberger Allee 392 fax: +49 30 549932-29 | 12681 Berlin mailto:stephan.born@beusen.de | Germany ---------------------------------------------------------------