Table of Contents
Using Tora in the Lab
The CS Dept Tora is located on the server at db1.chpc.ndsu.nodak.edu.
Connection Information
Following is the procedure to login to Tora from the workstations in the IACC 244 Lab:
- Click on the Application menu on the top left corner of your system. Under the submenu Programming, you will find Tora.
- You will be prompted to create a new connection. Select the following values:
- Connection Provider: Oracle (Instant Client)
- Username: This is your Unix ID (in my case, robefoer, not robefoer@CS)
- Password: This is your Oracle password.
- Host: db1.chpc.ndsu.nodak.edu
- Port Number: 1521
- Database: cs.ndsu.nodak.edu
Creating Tables using Tora
Once you've logged into the Oracle database via Tora, you now see the main application window.
To create new tables, you need to open up the Schema Browser . This is found under the Tools menu in Tora. From here, you can view your already existing tables, and can create additional tables.
Executing Queries using Tora
Once you've logged into the Oracle database via Tora, you'll still see the main application window.
To write and execute queries, you'll need to open up the SQL Editor. This is found under the Tools menu in Tora. From here, you can simply enter queries into the provided editor, and execute them as needed.