| 1 |
SQL is a very simple, yet powerful database access language, non-procedural and interpretive language
|
| 2 |
Oracle SQL has many extensions to the ANSI/ISO standard SQL language
|
| 3 |
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
|
| 4 |
Any other data access method would circumvent the security built into Oracle and potentially compromise data security and integrity
|
| 5 |
Data-independent --- two-phase database schema (logical and physical database)
|
| 6 |
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
|
