2.1.1 Importing Data from CSV Files
You can import data from CSV files into the database through Oracle SQL
Developer or by using Oracle Database utilities (such as SQL*Loader or External
Tables).
-
See Data Import Wizard in Oracle SQL Developer User's Guide on how to import data from files into tables.
- See Oracle Database Utilities for more information on data transfer utilities.
The following instructions enable you to load data into the database tables using Oracle SQL Loader.
As a prerequisite requirement, you must execute the following SQL
statements to create the vertex (
bank_accounts
) and edge
(bank_txns
) tables in the database:CREATE TABLE bank_accounts(id NUMBER, name VARCHAR2(10));
CREATE TABLE bank_txns(from_acct_id NUMBER, to_acct_id NUMBER, description VARCHAR2(10), amount NUMBER);
You can then perform the following steps to load the data:
The sample bank graph data is now available in the database tables.
Parent topic: Using Sample Data for Graph Analysis