Aaron
I assume so from the sytax does Oracle not have CASE, COALESCE and NULLIF
(These are ANSI SQL optional functions)
Neven
----- Original Message -----
From: Aaron Scott-Boddendijk <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Wednesday, 18 October 2000 15:27
Subject: Re: [DUG]: Query Parameters
> > However under ADO and MSSQL7 the following does work!
> >
> > select
> > case :FieldNo
> > when 0 then Column1
> > when 1 then Column2
> > end
> > from Table
>
> is that similar to the oracle decode?
>
> select decode(:FieldNo,0,Column1,1,Column2,null)
> from table;
>
> Assuming of course that ORACLE will bind a parameter to field in this
> case...
>
> Which I haven't tried...
>
> --
> Aaron Scott-Boddendijk
> INTAZ Limited
> +64 7 838 3371 Voice
> +64 7 838 3372 Fax
>
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
