{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

CS457C-10805A-sandeep anugula-Homework1

CS457C-10805A-sandeep anugula-Homework1 - CS457C Homework#1...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
CS457C Homework #1 1. Oracle Technology Network (OTN) User ID: [email protected] 2. SQL Reference: Numbers of SQL statements are constructed almost entirely of PL/SQL elements. Those statements continue to appear in this reference, but the bulk of their syntax and semantics has been moved to Oracle Database PL/SQL Language Reference . The following table contains links to both the abbreviated SQL syntax and semantics in this book and to the full syntax and semantics in Oracle Database PL/SQL Language Reference. Abbreviated SQL Section Full Syntax and Semantics CREATE FUNCTION CREATE FUNCTION CREATE PACKAGE CREATE PACKAGE CREATE PACKAGE BODY CREATE PACKAGE BODY CREATE PROCEDURE CREATE PROCEDURE CREATE TRIGGER CREATE TRIGGER CREATE TYPE CREATE TYPE CREATE TYPE BODY CREATE TYPE BODY ALTER FUNCTION ALTER FUNCTION ALTER PACKAGE ALTER PACKAGE ALTER PROCEDURE ALTER PROCEDURE ALTER TRIGGER ALTER TRIGGER ALTER TYPE ALTER TYPE
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
3. What language that Oracle database understands, give an example. Oracle Database understands Structured Query Language (SQL), which is a computer programming language, used to manipulate information in relational database management systems (RDBMS). SQL is both the American National Standards Institute (ANSI) and International Organization for Standardization (ISO) standard for accessing data in RDBMS. It is widely used by many database software systems, including My SQL, SQL Server™, Postgre SQL, and the Oracle® Database. While Structured Query Language is arguably easier to use than traditional computer programming languages, it is also considered to be a very powerful and often complex technology. For example, it can be used to insert or change information in database tables. It can also be used to remove that data. Another common method of using Structured Query Language involves changing the structure of the database itself. Perfect examples would be creating, modifying, or deleting tables or other objects within the database. SQL utilizes a set of commands to manipulate the information in a relational database. Among the most common examples are SQL INSERT, SQL SELECT, and SQL UPDATE. As the name indicates, SQL INSERT is used to input data into database tables. SQL SELECT is used to get select data from tables. The SQL UPDATE command is used to make alterations to existing database tables and records. All the necessary Structured Query Language commands in a corresponding RDBMS can typically be executed through an SQL command line interface (CLI). Example: A weather Report City Temperature Humidity Condition San Jose 66 63 Sunny San Francisco 54 60 Sunny Los Angeles 80 60 Cloudy A Simple SQL Query: Select city from weather where humidity = 60 Oracle would respond: City ---------- San Francisco Los Angeles
Image of page 2
Second Query would be like this: Select city from weather where temperature = 66 For this Query, Oracle would respond : City ------------- San Jose 4. List steps of system development life cycle?
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern