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 :confused:
Printable View
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 :confused:
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.