Re: IF-like function in Oracle?

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/09/28
Message-ID: <44ea6c$mfu_at_ixnews2.ix.netcom.com>#1/1

anarayan_at_sctcorp.com (Ananta Narayanan) wrote:

>If you are dealing with numbers, the function 'sign' would be of help
>to you.
> I have used 'decode' combined with 'sign' in a lot of SQL*Plus
>scripts.

I am indeed dealing with numbers. Dates to be specific. How would I do it though if I were dealing with VARCHARs?

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!

Received on Thu Sep 28 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Mike Philippens: "Re: IF-like function in Oracle?"
Previous message: Robert W. Swisshelm: "Re: how to change $ORACLE_HOME"
Maybe in reply to: Chuck Hamilton: "IF-like function in Oracle?"
In reply to Ananta Narayanan: "Re: IF-like function in Oracle?"
Next in thread: Mike Philippens: "Re: IF-like function in Oracle?"

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

Original text of this message