Clone wiki

rtfd / Home

Wiki: Oracle SQL & PL/SQL Optimization for Developers

The public git repository Oracle is for Sphinx (reStructuredText) source files pertaining to the Read the Docs project.

Issues are to be added to the issue tracker.

All development activities and the project roadmap are added to this wiki.

Introduction

To clone the project please use:

$ git clone git@bitbucket.org:databaseline/rtfd.git

To clone the wiki use:

$ git clone https://databaseline@bitbucket.org/databaseline/rtfd.git/wiki

The gitflow workflow is used throughout this project. The main branch is called master, and the development branch is known as develop.

Roadmap

Release Features Date Online
0.1 SQL: introduction
SQL: basics 2014/04 2014/04/27
0.2 SQL: execution plans 2014/07 2014/06/21
0.3 SQL: indexes 2014/09 2014/08/09
0.4 SQL: subqueries 2014/10 2014/11/28
0.5 SQL: joins 2014/12 2014/12/04
1.0 SQL: hints 2015/01 2014/12/03
1.1 PL/SQL: introduction 2015/03 2015/01/24
1.2 PL/SQL: bind variables 2015/04 2015/01/24
1.3 PL/SQL: loops, cursors, and bulk operations 2015/05 2015/02/14
1.4 PL/SQL: caching 2015/06 2015/04/02
2.0 Data modelling: partitioning N/A 2015/05/22
2.1 Data modelling: compression N/A 2015/08/28

The following is a list of possible features for upcoming releases:

  • PL/SQL: SQL injection
  • PL/SQL: Object-PL/SQL and ADTs
  • Data modelling: ER (Inmon) vs dimensional (Kimball)
  • SQL vs PL/SQL: IUD statements

Updated