From the course: Oracle Database 19c: Basic SQL
Join today to access over 25,500 courses taught by industry experts.
Inserting single rows
From the course: Oracle Database 19c: Basic SQL
Inserting single rows
- [Narrator] One of the most common DML, data manipulation language, statements you'll use is INSERT. I'll review the general syntax and walk through the rules for an insert statement and how it's used for inserting single rows into a table. First, I'd like to define DML statements. Simply, they make changes through a table. They can add rows, insert into a table, update them, delete them, or even merge into them, with MERGE being a combo of the first three. TRUNCATE is sort of a DML statement in that it does a mass delete but it's more of a DDL, data definition command. Any DML statement can affect zero, one, or many rows. In this lesson we're going to focus on insert and inserting one row at a time, much like in an OLTP system. Here's the high level syntax of the insert statement. You specify the table name you're inserting into, an optional schema name if the table is not in your schema, and the columns to be populated. The values clause is where you specify those values. For those…
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.