Data Manipulation Language
Oracle 12c
| Beginner
- 14 Videos | 1h 3m 26s
- Earns a Badge
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 SQLadd rows to a table in the database by using the INSERT SQL statementwork with NULL values during the INSERT SQL statement when adding rows to a tablework with SPECIAL values during the INSERT SQL statement when adding rows to a tablework with specific DATE and TIME values during the INSERT SQL statement when adding rows to a tablesave commands with substitution variables to a file and execute the commands in the fileuse the INSERT SQL statement to copy rows from one table to another
-
change data in a table using the UPDATE SQL statementchange data into two columns using a subquery to update the two columns using the UPDATE SQL statementchange the rows in a table based on a different table using the UPDATE SQL statementremove rows from a table using the DELETE SQL statementremove rows from a table based on a different table using the DELETE SQL statementuse the TRUNCATE SQL statement to delete all rows from a tableinsert and update rows in a table
IN THIS COURSE
-
1.Data Manipulation Language2m 26s
-
2.Adding New Rows to Tables using the INSERT Statement5m 9s
-
3.Inserting Rows with Null Values5m 18s
-
4.Inserting Rows with Special Values2m 35s
-
5.Inserting Specific Date and Time Values2m 52s
-
6.Creating a Script4m 7s
-
7.Copying Rows from Another Table5m 55s
-
8.Updating Rows in a Table7m 1s
-
9.Updating Two Columns with a Subquery5m 28s
-
10.Updating Rows Based on Another Table4m 35s
-
11.Deleting Rows from a Table4m 55s
-
12.Deleting Rows Based on Another Table3m 3s
-
13.TRUNCATE Statement3m 7s
-
14.Exercise: Manipulate Data in a Table6m 55s
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.