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