ch01 - P L / S Q L Oracle10g Developer: PL/SQL Programming...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
P L / S Q L Oracle10 g Developer: PL/SQL Programming Chapter 1 Introduction to PL/SQL
Background image of page 1

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

View Full DocumentRight Arrow Icon
P L / S Q L Oracle10 g Developer: PL/SQL Programming 2 Chapter Objectives After completing this lesson, you should be able to understand: PL/SQL and application programming Application models How documentation can be used SQL and PL/SQL tools The databases used in this book SQL SELECT statement syntax
Background image of page 2
P L / S Q L Structured Query Language SQL ( Structured Query Language ) is a database computer language designed for managing data in relational database management systems (RDBMS). Its scope includes data query and update, schema creation and modification, and data access control. Oracle10 g Developer: PL/SQL Programming 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
P L / S Q L SQL - History SQL was developed at IBM by Andrew Richardson, Donald C. Messerly and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL , was designed to manipulate and retrieve data stored in IBM's original relational database product Oracle10 g Developer: PL/SQL Programming 4
Background image of page 4
P L / S Q L SQL – Language Elements Clauses , which are in some cases optional, constituent components of statements and queries. Expressions which can produce either scalar values or tables consisting of columns and rows of data. Predicates which specify conditions that can be evaluated to SQL three-valued logic (3VL) Boolean truth values and which are used to limit the effects of statements and queries, or to change program flow. Queries which retrieve data based on specific criteria. Statements which may have a persistent effect on schemas and data, or which may control transactions, program flow, connections, sessions, or diagnostics. Insignificant whitespace is generally ignored in SQL statements and queries, making it easier to format SQL code for readability. Oracle10 g Developer: PL/SQL Programming 5
Background image of page 5

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

View Full DocumentRight Arrow Icon
P L / S Q L SQL – Language Elements Oracle10 g Developer: PL/SQL Programming 6
Background image of page 6
P L / S Q L SQL - Queries The most common operation in SQL is the query, which is performed with the declarative SELECT statement. A query includes a list of columns to be included in the final result immediately following the SELECT keyword. An asterisk ("*") can also be used to specify that the query should return all columns of the queried tables. Oracle10 g Developer: PL/SQL Programming 7
Background image of page 7

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

View Full DocumentRight Arrow Icon
P L / S Q L SQL - Queries The FROM clause which indicates the table(s) from which data is to be retrieved. The WHERE clause includes a comparison predicate, which restricts the rows returned by the query. The GROUP BY clause is used to project rows having common values into a smaller set of rows. The
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/17/2012 for the course GCIS 511 taught by Professor Liu during the Fall '10 term at Gannon.

Page1 / 44

ch01 - P L / S Q L Oracle10g Developer: PL/SQL Programming...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online