Adding Data

Oracle Database XE enables you to store data in tables by inserting rows into them. The records being inserted must match the structure of the table. Each record should have values that match the different columns in the table.

There are several ways add data to the database. You will learn how to :

• Insert data

  This is the most common method to load data. You can use the INSERT statement to load one record with each statement. There are two ways of performing an INSERT: a. Using the Object Browser b. Using SQL Worksheet

• Load data from the Utilities page

  You can use the Utilities page to load data into an Oracle database from: 1. A spreadsheet 2. A text document 3. An XML document You can also unload data in these formats.