Assignment 3: Oracle Table and Query Essay

Submitted By bwallace12

Words: 469

Pages: 2

Open Document

Assignment 3: Oracle Table and Query
Bradley Wallace
Strayer University
Professor Mark Cohen
CIS-111
January 27, 2013

This paper is to show how I created an Oracle Table with three columns and input five records into it also ran a Query to show all the input. First launch the putty application and open the one for our class that we created in week one. Sign into Oracle and input the command line (sqlplus [userID]@orcl/[password]) to reach the prompt that reads SQL>. For my database I am going to use NFL quarterbacks for my table creation.
First command I 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 and a semi colon is needed after each line in SQLplus. After inputting the user id and password I am at the SQL prompt, this step can be done in one long statement or individual ones, I chose to use one long one but either way will work and I have included examples of both in this paper.
For the long statement, just type in the following command line: Create table NFLQBS (Player_Team varchar(20), Player_Name varchar(20), Player_Number varchar(15)); then hit enter if done correctly it should read, “Table Created”, or if using the individual statements, then type: Create table NFLQBS, and then enter a 2 on the next line. On the following lines, we will create the columns. On line 2 type in, Player_Team varchar(20); then hit enter. On line 3 type in Player_Name varchar(20);, hit enter again. Then on line 4 type in Player_Number varchar(15); and hit enter. If done correctly it should read, “Table Created”. The picture below shows that the table has been created correctly and now I can

Essay on ACL MODEL IN ORACLE AND COMMON SECURITY FRAMEWORK

ACL MODEL IN ORACLE AND COMMON SECURITY FRAMEWORK Table of Contents ACL MODEL IN ORACLE AND COMMON SECURITY FRAMEWORK 1 1. Problem definition 1 2. Background 2 3. Objectives 2 4. Description of project 2 5. Identifying the Components of framework: LWUR (Lightweight users and roles), LWS (Light weight session), ACL (Access control list) 3 6. Forerunner of ACL model and XML format representation of ACL 4 7. ACE ordering/ First match semantics 7 8. Types of ACL 7 9. ACL inheritance…

Words 2304 - Pages 10

Essay on Sql Lab 4

as does the lecture and textbook. The second section in this lab builds on Lab 3. It is best to complete Lab 3 first before completing the second section in this lab. Required Software The…

Words 6774 - Pages 28

Unit 1 Research Essay

George Olivo Pt2520 3/19/14 Unit 1 research assignment 1: 1. SQL Server Release History Version Year Release Name Codename 1.0 (OS/2) 1989 SQL Server 1.0 (16 bit) - 1.1 (OS/2) 1991 SQL Server 1.1 (16 bit) - 4.21 (WinNT) 1993 SQL Server 4.21 SQLNT 6.0 1995 SQL Server 6.0 SQL95 6.5 1996 SQL Server 6.5 Hydra 7.0 1998 SQL Server 7.0 Sphinx - 1999 SQL Server 7.0 OLAP Tools Palato mania 8.0 2000 SQL Server 2000 Shiloh 8.0 2003 SQL Server 2000 64-bit Edition Liberty 9.0 2005 SQL Server 2005 Yukon…

Words 496 - Pages 2

Mis562 Week 2 Essay

MIS562 Week 2 Assignment Homework week 2 Part 1 1. SQL> --1. List all employee information in department 30. SQL> SELECT * FROM EMP WHERE DEPTNO = 30; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 7521 WARD…

Words 2140 - Pages 9

Five Applications And Tools Pre-Loaded On The Tfttwindows01 Server Desktop

application starts as a service on the system or must be run manually. WINDOWS APPLICATION LOADEDSTARTS AS SERVICE Y/N 1. tftpd32 Starts as a service 2. FileZilla Server Interface- The interface does not start as a service and must be ran manually 3. Wireshark – Does not start as a service and must be ran manually 4. Nessus Server Manager – Does not start as a service and must be ran manually 5. NetWitness Investigator – Does not start as a service and must be ran manually 2. What was the allocated…

Words 11873 - Pages 48

SQL help Essay

insert and modify tables in a relational database. Outcomes, aims and objectives The aim of the section is to learn how to create and modify tables in a relational database and insert data into those tables. At the end of this section you will be able to: • understand the data types available within an RDBMS • create and drop data tables in an RDBMS • insert data records into data tables • modify the structures of data tables • assign primary keys to tables. Approximate…

Words 7736 - Pages 31

Hahahah Essays

University of Education Township Campus Lahore Enterprise Resource Planning Assignment #2 Muhammad Haseeb Afzal........BSIT-S10-M04 Question#1 Define Moore’s Law and explain why it is significant in the development of ERP. Is Moore’s Law still holding? Moore's law predicts that this trend will continue into the foreseeable future. Although the pace has slowed, the number of transistors per square inch has since doubled…

Words 2826 - Pages 12

A Brief Note On The USM Material Requirement Planning System

databases using i2 software on a weekly basis. i2 is linked to all USM oracle databases for static data and SAP tables for dynamic data. The outputs from the i2 refresh are various reports and database tables. Some important tables are the location-wise forecast and the shortage report for each spare part in the USM network. These reports and tables are used by USM in generating many other tables using MS-Access and Brio. These tables/reports are then used for various decision making activities like forecasting…

Words 8945 - Pages 36

SAS� Deployment: What's In My Server Soup?

SAS Global Forum 2011 Systems Architecture and Administration Paper 363-2011 Understanding the Anatomy of a SAS® Deployment: What's in My Server Soup? Mark Schneider, Donna Bennett, and Connie Robison, SAS Institute Inc., Cary, NC ABSTRACT Did you want to better understand the pieces of a SAS metadata-based deployment and where they go and what they do? This paper highlights the major components of a metadata-based SAS deployment of solutions and business intelligence. Using the…

Words 8200 - Pages 33

Managing Information Technology (7th Edition) Essay

the Operating Manager in Information Systems CASE STUDY I-1 IMT Custom Machine Company, Inc.: Selection of an Information Technology Platform CASE STUDY I-2 VoIP2.biz, Inc.: Deciding on the Next Steps for a VoIP Supplier CASE STUDY I-3 The VoIP Adoption at Butler University CASE STUDY I-4 Supporting Mobile Health Clinics: The Children’s Health Fund of New York City CASE STUDY I-5 Data Governance at InsuraCorp CASE STUDY I-6 H.H. Gregg’s Appliances, Inc.: Deciding…

Words 239873 - Pages 960