W.Breitling <member28455_at_dbforums.com> wrote in message news:<2962758.1054821844_at_dbforums.com>...
> CASE in an assignment is valid in 8i. My example was in an 8i instance.
> You just have to have the syntax right.
>
> Originally posted by Vladimir M. Zakharychev
> > "Jaap W. van Dijk" wrote in message
> > news:n2gsdv81e7162v0h3fkn5qekb0vq6qmgs1_at_4ax.com"]news:n2gsdv81e-
> > 7162v0h3fkn5qekb0vq6qmgs1_at_4ax.com[/url]...
> >
> > SQL and PL/SQL are two different beasts, so quoting SQL Reference
> > for PL/SQL question is not correct, even though they share the same
> > SQL engine in 9i. PL/SQL User's Guide and Reference has its own
> > section on CASE and that assignment statement is pretty valid, just
> > not in 8i, which was OP's source of the problem.
> >
> > --
> > Vladimir Zakharychev (bob_at_dpsp-yes.com) http://w-
> > ww.dpsp-yes.com/http://www.dpsp-yes.com
> > Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
> > applications.
> All opinions are mine and do not necessarily go in line with those of my
> employer.
Your example is sql case expression, not pl/sql as in original post.
Received on Thu Jun 05 2003 - 22:44:19 CDT
