Updating two tables from single update statement ???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Updating two tables from single update statement ???

  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    72

    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

  2. #2
    Join Date
    Jun 2005
    Location
    London, UK
    Posts
    159
    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
  •  


Click Here to Expand Forum to Full Width