O'Reilly logo

Oracle Database 12c The Complete Reference by Bob Bryla, Kevin Loney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image

CHAPTER15Changing Data: INSERT, DELETE, UPDATE and MERGE

Until now, virtually everything you’ve learned about Oracle, SQL, and SQL*Plus has related to selecting data from tables in the database. This chapter shows how to change the data in a table—how to insert new rows, update the values of columns in rows, and delete rows entirely. Although these topics have not been covered explicitly, nearly everything you already know about SQL, including datatypes, calculations, string formatting, WHERE clauses, and the like, can be used here, so there really isn’t much new to learn. Oracle gives you a transparent, distributed database capability that inserts, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required