Scribd
Upload
26 views1 page

Aetut 17

The document outlines the steps for importing sample data into a workspace using SQL scripts. It details the process of running the Demo_Project_Basic_Tables.sql and Demo_Project_Basic_Data.sql scripts, ensuring successful execution with no errors. The expected results after running the scripts are specified for verification.

Uploaded by

Prashant Prajapati
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
26 views1 page

Aetut 17

The document outlines the steps for importing sample data into a workspace using SQL scripts. It details the process of running the Demo_Project_Basic_Tables.sql and Demo_Project_Basic_Data.sql scripts, ensuring successful execution with no errors. The expected results after running the scripts are specified for verification.

Uploaded by

Prashant Prajapati
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Importing the Sample Data

The Run Script dialog appears.

11. Click Run Now to run the Demo_Project_Basic_Tables.sql script.

The Manage Script Results page appears.

12. Click the View Results icon (magnifying glass).

Your results should indicate 37 Statements Processed, 37 Successful, and 0 With Errors.

You have populated the sample tables in your workspace.

3.3 Importing the Sample Data


Next, import the sample data.
Upload the Demo_Project_Basic_Data.sql script to your workspace and run it
in the SQL Workshop.

To upload the sample data to your workspace:

1. In the SQL results summary page, click the SQL Scripts breadcrumb.

2. Click Upload.

3. For Import file, click the appropriate button to browse your system for a file (for
example, in Chrome the Choose File button).

4. Navigate to the directory where you extracted the .zip file and open the files
folder or subdirectory.

5. Select the SQL script file named Demo_Project_Basic_Data.sql and click


Open.

6. Click Upload.

7. In the SQL Scripts list, click the Run icon (pencil) adjacent to the
Demo_Project_Basic_Data.sql script.

The Run Script dialog appears.

8. Click Run Now.

The Manage Script Results page appears.

9. Click the View Results icon (magnifying glass).

Your results should indicate 2 Statements Processed, 2 Successful, and 0 With Errors.

Populating Your Workspace 3-5

You might also like