Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Expression

Re: Expression

From: Missy Pont <missyp_at_excite.com>
Date: Wed, 3 Apr 2002 02:09:56 -0500
Message-ID: <a8e8t1$4mg$1@slb3.atl.mindspring.net>


Found it. It should be AS not INTO. Thank you very much Flado. Hope there are more helpful people like you in this group.

"Missy Pont" <missyp_at_excite.com> wrote in message news:a8e826$ln6$1_at_nntp9.atl.mindspring.net...
>
> > select case when A>B then 1 when A=B then null else 0 end
> > into result
> *
> > from dual;
>
> Gives:
> ORA-00905: missing keyword
>
> Why?
>
>
>
Received on Wed Apr 03 2002 - 01:09:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US