Databases Reference
In-Depth Information
insert into regions (region_id, region_name)
values (6, 'Antarctic');
1 row created.
savepoint region_6;
Savepoint created.
rollback to region_5;
Rollback complete.
commit;
Commit complete.
Only the REGIONS row with a REGION_ID of 5 is saved in the table after
the COMMIT.
Terms to Know
CHECK constraint
PRIMARY KEY constraint
constraint
read consistency
FOREIGN KEY constraint
transaction
NOT NULL constraint
UNIQUE constraint
