There are a variety of methods to extract, transform and load (ETL) data in and out of an Oracle database. This short article provides an overview of some of the basic options that are supplied with Oracle.
L is for Load Firstly, we need a table to load data into. This SQL script creates a table called PERSON.
create table person (person_id number(12), forename varchar2(200), surname varchar2(200), title varchar2(10), email varchar2(100), gender varchar2(1), ni_number varchar(30), address1 varchar2(100), address2 varchar2(100), town varchar2(100), county varchar2(100), postcode varchar2(10), country varchar2(100), phone varchar2(100), mobile varchar2(100), salary number(12), date_of_birth date); The following PL/SQL procedure may be used to populate this table with an arbitrary amount of data.
...