Enterprise System

Overview

Enterprise application can be considered as a system due to the integration with business processes.

  • Provide Business Logic
  • Integrate with business process

Type of Enterprise System

  • Accounting
  • Business Intelligence
  • Business Process Management
  • Content Management System
  • Customer Relationship Management
  • Database
  • Enterprise Resource Planning
  • Enterprise Asset Management
  • Supply Chain Management

Attribute

  • Distributed
  • Transnational
  • High-performance
  • Secured
  • Portable
  • Concurrent

PL/SQL Programming Concepts: Review

PL/SQL Run-Time Architecture

Image 699

Block Type

  • Procedure
  • Function
  • Anonymous

PL/SQL Block Structure

  • Declare
    • Variables, Cursors, User-defined exceptions
  • Begin
    • SQL Statement
    • PL/SQL Statement
  • Exception
    • Action to perform when exception occurs
  • End;

Type of Variables

  • PL/SQL Variables
    • Scalar
    • Reference
    • Large object (LOB)
    • Composite (Record, Collection)
  • Non-PL/SQL Variables
    • Bind variables

 

Reference:

http://people.inf.elte.hu/sila/DB1Pract/Oracle_PLSQL.pdf

 

 

 

 

Working with Java Data Types

  • Declare and initialize variables.
  • Differentiate between object reference variables and primitive variables.
  • Read or write to object fields.
  • Explain an object’s lifecycle.
  • Call methods on objects.
  • Manipulate data using the StringBuilder class and its methods.
  • Create and manipulate strings.

 

Primitive Data Types

  • byte
  • short
  • int
  • long
  • float
  • double
  • boolean
  • char

Advanced PL/SQL

  • Oracle11g: Advanced PL/SQL
  • PL/SQL Programming Concepts: Review
  • Designing PL/SQL Code
  • Working with Collections
  • Using Advanced Interface Methods
  • Implementing Fine-Grained Access Control for VPD
  • Manipulating Large Objects
  • Administering SecureFile LOBs
  • Performance and Tuning
  • Improving Performance with Caching
  • Analyzing PL/SQL Code
  • Profiling and Tracing PL/SQL Code
  • Safeguarding Your Code Against SQL Injection Attacks