image

image

he UPDATE statement lets you change data in tables and views by resetting values in one or more columns. A single UPDATE statement can change one, many, or all rows in a table. The new values can come from literal values, variables, or correlated query results. Correlation is the matching of one set of data with another through join operations. This chapter discusses equijoin (equality value joins); Chapter 11 examines join options in detail.

Oracle and MySQL implement basic UPDATE statement syntax in a similar way, but Oracle supports a record ...

Get Oracle Database 11g & MySQL 5.6 Developer Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.