O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

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

Chapter 15

Table Operations

Abstract

SQL is tiered and some operations work at that level.

Keywords

BEGIN ATOMIC

Bulk load

COMMIT

CURRENT OF < cursor name >

DELETE FROM statement

ELSE

INSERT INTO statement

MERGE statement

Redundant duplicates

ROLLBACK

ROWID

SET

THEN

UPDATE statement

USING

WHEN [NOT] MATCHED

WHERE

There are only four things you can do with a set of rows in an SQL table: insert them into a table, delete them from a table, update the values in their rows, or query them. The unit of work is a set of whole rows inside a base table.

When you worked with file systems, access was one record at a time, then one field within a record. As you had repeated groups and other forms of variant records, you could change the structure of ...

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