Load data into the table

Double-click the Start Here icon from the Desktop to open the Browser and click the Run APEX bookmark.

Enter the following credentials and click Login.
Workspace: hr
Username: hr
Password: oracle

Select SQL Workshop > Data Workshop.

Under Data Load, select Text Data.

You want to upload a file and load it into the PROJECTS table. Select Existing table for Load To and click Next.

Select PROJECTS for Table Name and click Next.

Click Browse.

Select the /home/oracle/Desktop/solutions/apexp1_lab/projects.txt file and click Open.

The file is tab delimited. Change the Separator to \t and click Next.

The column mapping information is displayed. Click Load Data.

The data was loaded successfully. In the next topic, you add a Unique Constraint on the EMPLOYEES table.