1 Introduction to Oracle
Welcome to Oracle! The purpose of this document is to help you become familiar
with some of the more common Oracle SQL statements. This document is intended
to supplement the lectures and the online tutorials. After attending the
lectures, this document will be much easier to understand. The lectures
will talk about SQL in general and how to apply and understand concepts
like nested SELECTs and cursors. Once that has been understood, the transition
from ANSI SQL [ANSI = American National Standards Institute] to Oracle
SQL is just a matter of knowing the syntax.
This document is presented in a glossary format with essential Oracle
statements arranged in alphabetical order. This is not an exhaustive list,
but should be enough for your homework. The keywords contained in this
document are for SQL*Plus and not Pro*C++. While many commands can be preceded
by "EXEC SQL" and placed in a Pro*C++ .pc file, some commands should not
be placed in a .pc file. For example, one would not put commands like CREATE
TABLE or CREATE SYNONYM in a .pc file since they would only be used once.
Oracle v8 is covered by this document.