COMPONENTS OF THE ORACLE SERVER.


  • Procedural Option.
    The foundation of this option is Oracle programming language, called PL/SQL. With this option, you can implement the following features.

  • Stored Procedures.
    Stored procedures are programs that are stored in the Oracle database and perform central functions for your installation

  • Database Triggers.
    These are code stored in the database triggered by events that occur in your applications.

  • Packages.
    Packages group procedures together and store the the code as a single program unit database

  • Distributed Option.
    The distributed allows users to work with data in remote database as if it resided locally

  • Parallel Server Option.
    Some manufactures make clustered computers:each machine in the cluster has its own memory,yet they have common disk storage devises. Parallel server option allows Oracle to operate with this configuration

    • Back to components.

  • Parallel Query Option.
    Parallel qvery option caters to computers with multiple CPUs, and allows query processing to be split between multiple server processes.


    • Back To SQL/Oracle training