Manipulating Data in Oracle Database 10g

This course is included in our On-demand training solution.

Overview

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

165 min.

Course Objectives

Manipulating 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?