Oracle

My Oracle Notes

back

Building Blocks

- SQL

  • MERGE
  • SELECT CASE
  • SELECT with escape character
    •

    - PL/SQL

  • Flowerbox
  • Package Specification
  • Package Body
  • EXECUTE
    •

    - Scripts & Samples

  • Associative Array
  • Create Oracle Demo Schemas
  • Create Basic Testenvironment
  • Check Object
  • Check Feature Usage
  • Dynamic SQL
  • FOR..IN LOOP
  • Gather Statistics
  • Long Runner
  • Random Values
  • SQL*Plus Column Optimizer
  • Test Cases "Busy Objecst"
    •