NDSU CS Department Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== 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.