DECODE

Hi,

I'm looking around for an example of this. Can you update a table with a DECODE statement which gets values from another table?

So, something like this:

UPDATE table1
SET column1 = DECODE(some value of a select statement.......

So, I want to update the column with one of two values depending on the result of a query against another table....

Yes?

Thanks,

John Received on Tue Jun 24 2008 - 12:09:31 CDT