Clarification of site content.
Topics include: Optimization, Analyze Command, Full Table Scan Versus Indexes, Hints, Subqueries, Join, Set Operation, Bind Variables, Null, Truncate Table versus Delete, Execution Plan, Explain Plan, SQL Trace Facility, and Autotrace.
Topics include: Structure of PL/SQL, anonymous block, procedures, functions, triggers, and packages. The implicit CURSORS and explicit CURSORS are described. Conditional control statements and sequential control statements are discussed. Additional linked pages describe parameters and basics debugging technique
The six groups of Oracle database command are Data Definition Language, Data Manipulation Language, Data Control Language, Transation Control Commands and Embedded SQL Commands.
SQL*Loader is an Oracle utility that allows you to load ASCII files into Oracle database tables.
Diagram of a three-tier network architecture linking web servers and DBMS systems.
CORBA or Common Object Request Broker Architecture is the next generation of middleware and is ideal for creating scaleable 3-tier client server solutions.
Commercial SQL database vendors offer two basic techniques for using SQL within a web application program: API and embedded SQL. This is a discussion of some of the API and embedded SQL options.
How GIF and JPEG compression works.The difference between GIF and JPEG compression. When to use each.