From the course: Learning Oracle Database 12c
Join today to access over 25,300 courses taught by industry experts.
Data manipulation language (DML): Explained - Oracle Database Tutorial
From the course: Learning Oracle Database 12c
Data manipulation language (DML): Explained
- [Narrator] Let's talk about Oracle Data Manipulation Language, DML for short. What do you need DML for? Well, you can select from tables all day, but if you want to make any changes to your table, you're going to have to use a DML statement, such as insert, update, or delete, and those names are somewhat self explanatory, but we'll go into more detail. And then there's truncate, which is sort of like a delete, and we'll explain why. Here's the insert statement, the syntax for it. You insert into a specific table, you specify the columns you want to insert into, and the values clause specifies what values you want to actually insert into a row of the table. If you omit the columns, then the assumption is you're inserting all columns for that table. Here are a couple of examples. We want to insert a new row into departments. We have a new department being formed in this company. We specify just the columns we want to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.