Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

Index

A

Abbreviations

Abjads

Active session history (ASH) data

drawback

relational interface

Adaptive cursor sharing

Adaptive query plans

ADD FUNCTION command

Advanced grouping

CUBE

GROUPING sets

ROLLUP syntax

Aggregate functions

Agile environment

Algorithm analysis

Aliases

ALTER commands

ALTER PACKAGE command

ALTER TABLE command

Amdahl’s law, 1/((1-P)+P/N)

Analytic function row limiting

Analytic function syntax

ANSI joins

Anti-patterns, avoid

automation

cargo cult syntax

CURSOR

definition

deprecated features

generic errors

Java in database

object relational database

parameters

second system syndrome

soft coding

SQL parsing

TO_DATE

undocumented features

APPEND hint

Application Express (APEX)

Arcane features

advanced compression

ANYDATA object

ANYDATASET object

ANYTYPE object

APEX

cellular ...