Updating a table from another table

Cross table update (also known as correlated update, or multiple table update) in Oracle uses non-standard SQL syntax format (non ANSI standard) to update rows in another table. Update data in table A based on two or more common columns in table B.The differences in syntax are quite dramatic compared to other database systems like MS SQL Server or My SQL. Updates based on two or more common columns are normally used for tables where multiple columns work together as a primary key (known as composite primary key).When the subquery fails to find a matching row in tbl B, the subquery returns NULL.

Consider a help desk application that allows support staff to create support tickets, where each ticket in the system exists as a record in the Tickets table. To ease data entry, let's say that administrative users can create "ticket templates," which pre-define the values for a number of ticket data points that are stored in a table named Ticket Templates.

[closed] Libreoffice base : can open mysql but not insert new record [closed] Cannot uninstall 3.4 due to "Please exit Libre Office" [closed] Base: Forms: Event properties for Macros [closed] How do I create a database of contacts for basic mailing / label / group management?



  1. Pingback:

  2. eric   •  

    Be less concerned about getting her approval and start teasing her a bit more.

  3. eric   •  

    Among them was Danica Patrick, who posted a photo of herself after she caught Reimann's bouquet: The 42-year-old Earnhardt missed all but 18 races this past season because of a concussion, but he was cleared to return to action in early December.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>