-
Updating two tables from single update statement ???
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|