On Thu, 24 Aug 2006 23:08:09 +0200, Ruben Schoenefeld
<Ruben.Schoenefeld@uni-oldenburg.de> wrote:

>not a silly question. The point of the post is that I wanted to know
>if it's going to work before I even give it to the DBA in charge of
>creating the database.

Ahh, I see, so you want US to try it.
The only thing I remember (from a while ago) is constructs like you
posted do NOT work, and you are limited to using DECODE expressions
returning *boolean* true or false.

--
Sybrand Bakker, Senior Oracle DBA