CSCE 520
Homework 1
Due August 31, 2017


Read Chapter 1 and sections 2.1, 2.2, and 2.3 of Chapter 2. This should not be taxing, as it is mostly nontechnical.

To submit

The purpose of the rest of this assignment is to get you to start using Oracle from a Linux client (one of our lab machines), which is what you'll be doing throughout the course.

Logon to one of our Linux lab machines, either remotely (via ssh using port 222) or by going to the Linux lab. A typical Linux lab computer's name is, where 'xx' stands for any two-digit number from 01 to 20. The command I use for this on my Macbook Terminal program is

$ ssh -p222

(You will need to have some type of two-factor authentication and a VPN (virtual private network) set up to access the linux machines from outside campus.) I'm assuming that you have at least basic familiarity with Linux, including navigating the file system, running commands, and editing text files.

At the Linux shell prompt, type

$ sqlplus64

For example, I would type


You should then be prompted for a password. Initially, your password is the same as your network username (before the @-sign, above). Your first task is to change your password to something secure. Your new password must be between 6 and 30 characters and begin with an alphabetic character. WARNING!!! unfortunately, Oracle does NOT allow special characters (that is, characters other than alphanumeric characters); if you use them in your new password, you may be permanently locked out of your account. Alas, Oracle is a ridiculously backward platform when it comes to this aspect of security.

To change your password: at the SQL prompt, type

SQL> password

and follow the prompts. You may quit your SQL session at any time by typing exit at the SQL prompt.

Oracle is a client-server application. When you run an Oracle session, you are actually interacting with a client program sqlplus64 on your local lab machine, which then sends commands and retrieves data from the oracle server (running on the machine "oracle"). Your oracle sessions will involve simple scrolling text only and not GUIs.

If you have any questions or problems related to Oracle accounts or running Oracle, please contact the Teaching Assistant (see the Syllabus for contact info), who is also the Oracle administrator for this class.

Oracle Exercise

Create a table called yourLastName_table, where yourLastName is your own last name. Follow these steps, and when you're done, you will see a file named hw1.lst in your directory.

Note the semicolons at the ends of some of the commands.

SQL> spool hw1
SQL> create table yourLastName_table ( name char(20) );
SQL> insert into yourLastName_table values( 'yourLastName' );
SQL> select * from yourLastName_table;
SQL> spool off
SQL> exit

You should turn in your hw1.lst file electronically using CSE Dropbox. You should submit your assignment to Section 001 regarless of what section you are in.

This page was last modified Wednesday August 23, 2017 at 13:53:30 EDT.