I'm not sure I would call it "great", but it IS very useful - it allows you to code an in-line IF-THEN-ELSE logic in your SQL.
As to the original question - I believe it IS in the OCP exam, but I would guess you will only see one question about it.
DECODE :-( the statement from hell....... (I don't like it much, but I hide it well -- don't you think?) Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.