Data Manipulation Language

Oracle 12c
  • 14 Videos | 1h 6m 56s
  • Earns a Badge
Likes 37 Likes 37
Oracle Database 12c objects contain data, and that data needs to be managed. Learn about manipulating tables by inserting, updating, deleting, and truncating rows.

WHAT YOU WILL LEARN

  • define the Data Manipulation Language in SQL
    add rows to a table in the database by using the INSERT SQL statement
    work with NULL values during the INSERT SQL statement when adding rows to a table
    work with SPECIAL values during the INSERT SQL statement when adding rows to a table
    work with specific DATE and TIME values during the INSERT SQL statement when adding rows to a table
    save commands with substitution variables to a file and execute the commands in the file
    use the INSERT SQL statement to copy rows from one table to another
  • change data in a table using the UPDATE SQL statement
    change data into two columns using a subquery to update the two columns using the UPDATE SQL statement
    change the rows in a table based on a different table using the UPDATE SQL statement
    remove rows from a table using the DELETE SQL statement
    remove rows from a table based on a different table using the DELETE SQL statement
    use the TRUNCATE SQL statement to delete all rows from a table
    insert and update rows in a table

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 45 Likes 45  
Likes 51 Likes 51  
Likes 53 Likes 53