The interactions in this eCourse require Javascript to be enabled.
Adding Data
previous|next
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.