O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating data with INSERT

Our first look at manipulating data involves one of the most fundamental operations in an RDBMS—the ability to add data. This section looks at ways to create data within an Oracle database.

Examining the syntax of the INSERT statement

The primary command in SQL that allows users to create the data that resides in tables is the INSERT statement. With it, we can add rows to an existing table, provided that the format we use for the statement fits with the existing column structure. The syntax tree for the basic INSERT statement is as follows:

INSERT INTO {table_name}
VALUES (value1, value2, ... );

Considering the lengths to which we've taken our SELECT statements thus far, it may seem that the syntax for the INSERT statement ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required