The Adriani's Oracle Project (AOP) is a introduction tutorial to Oracle SQL and PL/SQL.

This tutorial DOES NOT provide any documentation nor instruction, offering instead some code samples covering the major topics: the tutorial starts from the SQL basics (create a table, run a simple SELECT query etc.) and moves on towards more complex topics, including PL/SQL programming, using triggers, creating packages and finally using an automatic procedure to manage any DDL/DML operation.

Aims of the tutorials are:

• Providing a very quick starts for developers having already some practice with other databases. These people usually are not interested in reading some theoric information, since they already know the basic concepts concerning databases: this tutorial offers a lot of working example, which can be used to acknowledge the Oracle syntax, skipping any theoretic introduction.
• Offering a quick reference for experts users that needs to recover some syntax hints when working off-line: you can use this tutorial to copy-paste the samples you need and modify them.
• Implement a basic benchmark system which can be used to monitor an actual system, counting all "calls" to the system, and analysing all "sub-calls" (named "entities") making up a single call.

Download