Assignment 3: Oracle Table and Query
Arthur David Knowles
Professor Murnane
CIS 111
Strayer University

10, 29, 2012

Assignment 3: Oracle Table and Query Today we are going to learn how to do a couple basic things within Oracle. We are going to create a table with three columns and we are going to input five records into it. When we are all done you will be able to create a table, insert data and use a query to find the data. Now let us get started! First launch the putty application and open the one for our class that we created week one. Sign into Oracle until you reach the prompt that reads SQL>. For this example I am going to use NFL quarterbacks for our table creation. Once you have arrived at the SQL prompt type in the following command line, create table NFLQBS ( , then hit enter, you should see a 2 on the left side, on the following lines we will create the columns. On line 2 type in, Player_Team varchar(30), then hit enter. On line 3 type in Player_Name varchar(30), hit enter again. Then on line 4 type in Player_Number varchar(5); and hit enter. If done correctly it should read, “Table Created”. The picture above shows where we should be. I will now explain a few of the things we just did in detail. First command we used was Create Table, this is used to create the base table that forms the heart of our relational database. The number in parentheses is used to set how many character can be used in that column. Now we will move onto inserting the data into our table. To do this we will use the insert command which allows us to put new records into the table. I will show you how to input one record into the table then I want you to do it five times and five different records. We will use the following command line. At the SQL prompt type in, Insert into NFLQBS (Player_Team, Player_Name, Player_Number) Values (‘Dallas Cowboys’, ‘Tony