Using Putty, WS_FTP or Oracle SQL

On-Campus

1. On a UHD computer, select PuTTY from Start > All Programs.

2. Follow steps starting from Step 6 below.

Off-Campus

1. Download PuTTY if not installed: PuTTY Download.

2. Click putty.exe and save it to your preferred location.

3. Double-click the PuTTY icon to launch.

4. In the PuTTY Configuration window:

   • Host Name: gator.uhd.edu

   • Protocol: SSH

   • Click Open.

   • (Optional) Save the session by typing Gator in Saved Sessions and clicking Save.

5. At the login as prompt, enter your username and press Enter.

6. Enter your password (cursor will not move) and press Enter. Once logged in, you’ll see a prompt like:
   [username@gator username]$

Access Oracle SQL Using Your Linux Account

1. Log into Linux following the steps above.
2. At the command prompt, type:
   sqlplus / and press Enter.
3. If you have Oracle database access, you’ll see the SQL> prompt.

Create an SQL Program File

• Use the Pico text editor:
  $ pico yourfile.sql
• Ensure the file has a .sql extension (Linux is case-sensitive).
• Paste your SQL code into the PuTTY session.
• Save and exit:
  Ctrl + X, then Y, then Enter.
  (To exit without saving: Ctrl + X, then N, then Enter.)
• Run your SQL program:
  SQL> @yourfile.sql