Re: Functions in Update

Try this, not sure about Oracle's select merge rules, you may end up with Ron's proposal anyway if func1() is deterministic.

UPDATE mytable SET (col2, col3)

• (SELECT col1, func2(col1, col2) FROM (SELECT func1(col1) as col1 FROM DUAL) AS T);

Cheers
Serge

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab