|
SQL is a very simple, yet powerful database access language, non-procedural and interpretive language
|
|
Oracle SQL has many extensions to the ANSI/ISO standard SQL language
|
|
Although some Oracle tools (PL/SQL,Pro*C,Oraperl) and applications simplify or mask the use of SQL, all database operations are performed using SQL
|
|
Any other data access method would circumvent the security built into Oracle and potentially compromise data security and integrity
|
|
Data-independent --- two-phase database schema (logical and physical database)
|
SQL in Oracle 7 will do the following:
-
Create tables in the database
-
Store information in tables
-
select exactly the information you need from your database
-
Make changes to your data and the structure of underlying tables, and
-
Combine and calculate data to generate the information you need
|
