Manipulating Data in Oracle Database 10g
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Overview/Description
To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with RDBMS technologies and programming techniques
Expected Duration (hours)
2.8
Lesson ObjectivesManipulating Data in Oracle Database 10g
insert rows into a table.
update and delete rows in a table.
insert, update, and delete data.
control data changes and identify how read consistency is implemented.
control data changes using the COMMIT, SAVEPOINT, and ROLLBACK statements.
manipulate data in Oracle 10g by using subqueries.
use various types of multitable inserts.
use the MERGE statement and the Flashback Version Query feature.
perform multitable INSERT and MERGE operations, and track row versions.
Course Number:223297_eng