Differences

This shows you the differences between two versions of the page.

--- classes:csci366:tora [2017/01/14 21:46] – created localadmin
+++ classes:csci366:tora [2017/01/14 21:48] (current) – [Creating Tables using Tora] localadmin
@@ Line 2: / Line 2: @@
 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.