Re: trivial decode NOT

From: Keith70127 <keith70127_at_aol.com>
Date: 1995/04/20
Message-ID: <3n4tu6$8c8_at_newsbf02.news.aol.com>#1/1

Saw your use of subtraction and division and trunc to determine range using decode. Seems simplier to me to use the sign function on a subtration.

decode(sign(dept - 150, -1   -- then must be less than 150
decode(sign(dept - 150, 0    -- then must be equal to 150
decode(sign(dept - 150, 1    -- then must be geater than 150

Keith70127_at_aol.com
D. Keith Midkiff Received on Thu Apr 20 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Telerate: "Re: force use of an index - how to?"
Previous message: Stephen Newhouse: "Re: EXCEPTION with Personal Oracle, Code: 0xC0000005, HELP"
In reply to: febbo_at_madnix.uucp: "Re: trivial decode NOT"
Next in thread: Venky Potdar: "Re: trivial decode NOT"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message