Re: pl/sql greatest function

Fred Allison (fallison_at_mail.thesysgrp.com) wrote:
: >
: > btw, DECODE is not supported also.
:
: News to me. I must do something about all this PL/SQL code
: I've got with DECODES in it.

Yes & No.
You can use decode on the select statement, but not in the procedural language itself. eg:
var := decode(a,1,0,1); -- is not valid
of course you can get round this by:
select decode(a,1,0,1) into var from sys.dual;

-- 
                                          vvv
steve corbett                           [ . .]
                                           |
scorbett_at_perth.dialix.oz.au     _____oOO_______OOo_____