1. Introduction ------------ - SQL. Language constructions. DDL, DML, DCL and query sublanguages. SQL usage in Oracle. PL/SQL. Datatypes. ROWIDs. Integrity constraints. DB triggers, procedures, packages. Mechanism for constraint checking. Indexes. Disabling and enabling triggers. - Transactions. Commit and rollback. - Oracle's approach to client-server computing. Oracle software on server and client sides (RDBMS+TOOLS). - SQL*Net V1 and SQL*Net V2. - Data dictionary. SYS and SYSTEM users. DBA_, USER_, ALL_ tables. Dynamic performance V_$... tables. - USER and SYSDATE variables. - Steps of SQL statement processing. PL/SQL on client and server sides. Two task and one task architecture. - Oracle tools survey. Application tools and end-user (decision support) tools. Character mode application tools on server and client sides. GUI based bitmapped tools. CDE1 and CDE2. CASE. Tools for MS-Windows. DBA tools. EXPort and IMPort, SQL*Loader and SQL*Plus. Third-party tools.