DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. 09-24-2005, 06:20 AM #1
    Sathy
    Sathy is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 09-24-2005, 05:33 PM #2
    WilliamR
    WilliamR is offline Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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