Course details

Oracle Database 12c R2 SQL: Data Manipulation Language and Transaction Control Language

Oracle Database 12c R2 SQL: Data Manipulation Language and Transaction Control Language


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Once an Oracle 12c relational database has been created with objects, the data in these objects needs to be managed. Discover how to insert, update, delete, and truncate rows.



Expected Duration (hours)
1.0

Lesson Objectives

Oracle Database 12c R2 SQL: Data Manipulation Language and Transaction Control Language

  • define the Data Manipulation Language in SQL
  • add rows to a table in the database by using the INSERT SQL statement
  • insert rows with NULL values
  • insert a special value in a table
  • change data in a table using the UPDATE statement
  • remove rows from a table using the DELETE and TRUNCATE statement
  • use the COMMIT and ROLLBACK statements
  • use the SAVEPOINT statement
  • describe a statement level rollback
  • guarantee consistent view of data at all times
  • demonstrate when to use the FOR UPDATE and LOCK table statements
  • insert and update rows in a table
  • Course Number:
    it_dfosfd_02_enus

    Expertise Level
    Beginner