mscich/oracle-patterns

Database Objects

Indexes

Sequences

Tables

Alter Table

Partitions

Virtual Columns

Triggers

Types

Views

Installed

dbms

dbms_lock

If PLS-00201: identifier 'DBMS_LOCK' must be declared is thrown, connect as sysdba, then

grant execute on dbms_lock to user;

dbms_sql

utl

utl_file

PL/SQL

authid

bulk collect

Conditional Compilation

Collection Types

exception

loop

Nested Tables

SQL

functions

null related

regular expressions

merge

select

analytical functions

group by

order by

pivot

SQLLoader

SQL*Plus

UsersRoles