Updating two tables from single update statement ???

[Sathy]

Hi,

Is it possible for updating two tables from one single update statement ????

Is it possible for getting two values from function ???

Can any one help me !!!

--Sathy

[WilliamR]

1. No, UPDATE operates on one table only. If the table or view had a trigger, it could perform additional updates. I'm not sure it would be the best approach, though.

2. Yes, a function can return an object or PL/SQL record with multiple attributes, or a collection, or a row of a TABLE() expression using PIPE ROW, or a ref cursor.