Morgan's Library
 
Morgan's Library has become one of the web's most important resources expanding, over the years, to more than 570 pages accessed each month, more than 1.1 million times, by developers and DBAs in more than 180 countries and domains
To keep this resource available to the community please join with others and help to support the cost of hosting this site, its continued expansion, and the ongoing process of translating pages into multiple languages by donating $25 or more. Thank you.
Languages: Chinese English French Spanish Thai        Coming Soon
 
Home

Community
Events
Training
Evening Workshops

Resources
Library
How Can I?
Code Samples
Presentations
Links
Book Reviews
Downloads
User Groups

General
Contact Us
About Us
Services
Legal Notices & Terms of Use
Privacy Statement
 
Library Key
Version Highest version number tested
New page posted in last 30 days
Updated page in last 30 days
Examples Key
  Demo tested successfully
TBD To be developed / incomplete


Morgan's BLOG Class Setup Instructions
Morgan's Library began as a collection of code demos Morgan created for his students at the University of Washington. This is the only authorized copy of the library. Unauthorized clones are not maintained and  may contain critical errors and omissions.
Google  


wwwlibrary
Best Practice Built-in Functions Built-in Packages New in 11gR1 New in 11gR2
Topic Version Last Modified Comment
Active Data Guard 11gR2 18-Jun-2010 -
Active Session History 11gR2 08-Nov-2009 -
Add Binding Clause 11gR2 01-Sep-2009 -
ADDM Demo 11gR2 01-Sep-2009 -
ADR Command Interpreter 11gR2 06-Oct-2009 -
Advanced Compression 11gR2 05-Sep-2009 -
Advanced Queuing Stand-Alone Demo 11gR2 12-Dec-2009 -
Advanced Queuing RAC Demo 10.2.0.3 04-Jul-2009 -
Analytic Functions 11gR2 25-Jan-2010 -
Analyze 11gR2 25-May-2010 -
Anonymous Block 11gR2 10-Feb-2010 -
Anydata Data Type 11gR2 14-Jun-2010 -
Application Server (OAS) 10.1.2.0.2 07-Feb-2007 -
Application Server (OAS) 10.1.3.0.0 07-Feb-2007 -
Archive Logs 11gR2 01-Sep-2009 -
Array Processing 11gR2 21-Jun-2010 -
Arrays: Index by BINARY_INTEGER 11gR2 21-Jun-2010 -
Arrays: Index by VARCHAR2 11gR2 21-Jun-2010 -
AS OF Queries 11gR2 11-Sep-2009 -
AS REPLAY 11gR2 02-Jul-2010 -
ASH 11gR2 08-Nov-2009 -
Associate Statistics 11gR2 10-Sep-2009 -
Associative Arrays 11gR2 01-Sep-2009 -
Audit Vault 10.2.3 12-Aug-2009 -
Auditing 11gR2 20-Mar-2010 -
AUTHID (DEFINER and CURRENT_USER) 11gR2 01-Sep-2009 -
Automatic Diagnostic Repository (ADR) 11gR2 06-Oct-2009 -
Automatic Workload Repository 11gR2 01-Sep-2009 -
Automatic Workload Repository Report 11gR2 01-Sep-2009 -
Autonomous Transactions 11gR2 01-Sep-2009 -
Autotrace 11gR2 01-Sep-2009 -
AWR 11gR2 01-Sep-2009 -
AWR Report 11gR2 17-Aug-2010
Backup, Restore and Recovery 11gR2 16-Mar-2010 -
B*Tree Indexes 11gR2 22-Aug-2010
Bidirectional Cursor 11gR2 01-Sep-2009 -
Bind Variables 11gR2 01-Sep-2009 -
Bitmap Indexes 11gR2 22-Aug-2010
Bitmap Join Indexes 11gR2 22-Aug-2010
BLAST_CUR 11gR2 01-Sep-2009 -
Block Change Tracking 11gR2 19-Jul-2010 -
Block Dump 11gR2 02-Sep-2009 -
Breaking Oracle (UKOUG demos) 11.1.0.7 19-Jan-2010 -
BSQ Files 11gR2 01-Sep-2009 -
Built-in Arrays 11gR2 21-Jun-2010 -
Built-in Functions 11gR2 25-Dec-2009 -
Built-in Packages 11gR2 01-Sep-2009 -
Buffer Pool 11gR2 14-Jun-2010 -
Bulk Binding / Bulk Collection 11gR2 02-Jun-2010 -
CASE Function 11gR2 21-Apr-2010 -
Cast Function 11gR2 11-Jul-2010 -
Chained Rows 11gR2 01-Sep-2009 -
Change Data Capture - Sync 11gR1 05-Dec-2008 -
Change Data Capture - HotLog 11gR1 05-Dec-2008 -
Change Data Capture - AutoLog 11gR1 05-Dec-2008 -
Character Sets 11gR2 08-Feb-2010 -
Character Set Functions 11gR2 01-Sep-2009 -
Check Constraint 11gR2 09-Sep-2009 -
Clustering Factor 11gR2 14-Jun-2010 -
Clusters 11gR2 21-Feb-2010 -
Codd's Rules - 07-Jul-2007 -
Collections 11gR2 21-Jul-2010 -
Collection Functions 11gR2 03-Jun-2010 -
Colored SQL 11gR2 01-Sep-2009 -
COLUMN_VALUE 11gR2 08-Sep-2009 -
Commit 11gR2 01-Sep-2009 -
Common Table Expressions 11gR2 01-Nov-2009 -
Compilation: Interpreted and Native 11gR2 01-Sep-2009 -
Compiler Directives 11gR2 09-Sep-2009 -
Compound Triggers 11gR2 01-Sep-2009 -
Composite Partitioning 11gR2 08-Jun-2010 -
Compressed Indexes 11gR2 22-Aug-2010
Compressed Tables 11gR2 05-Sep-2009 -
Compressed Tablespaces 11gR2 05-Sep-2009 -
Conditional Compilation 11gR2 01-Sep-2009 -
Conditions 11gR2 02-Jun-2010 -
Connect By 11gR2 10-Nov-2009 -
Constants 11gR2 10-Feb-2010 -
Constraints 11gR2 06-Apr-2010 -
Consumer Groups 11gR2 01-Sep-2009 -
Contexts 11gR2 01-Mar-2010 -
Continue Statement 11gR2 01-Sep-2009 -
Control Data Capture: Synchronous Demo 11gR2 08-Aug-2010
Control Data Capture: Synchronous Demo 11gR2 08-Aug-2010
Control Data Capture: Synchronous Demo 11gR2 08-Aug-2010
Control Files 11gR2 01-Sep-2009 -
Control Structures 11gR2 26-Feb-2010 -
Conversion Functions 11gR2 03-Jun-2010 -
Create Database 11gR1 22-Feb-2009 -
Create Schema 11gR2 09-Sep-2009 -
Cross Edition Triggers 11gR2 02-Mar-2010 -
Cross Tabulation and Pivot Operators 11gR2 01-Sep-2009 -
CRS_STAT 11gR1 15-Oct-2008 -
CSALTER 11gR2 08-Feb-2010 -
CSSCAN 11gR2 08-Feb-2010 -
CTX_DDL 11gR2 01-Sep-2009 -
Cube 11gR2 10-Nov-2009 -
Cursor Sharing 11gR2 01-Sep-2009 -
Cursors & Cursor Loops 11gR2 26-Feb-2010 -
DANGLING 11gR2 01-Sep-2009 -
Data Control Language (DCL) 11gR2 02-Sep-2009 -
Data Dictionary 11gR2 14-Jun-2010 -
Data Files 11gR2 01-Feb-2010 -
Data Guard 11gR2 18-Jun-2010 -
Data Integrity 11gR2 02-Sep-2009 -
Data Mining Functions 11gR2 02-Sep-2009 -
Data Pump (API) 11gR2 14-Jun-2010 -
Data Pump (Executable) 11gR2 24-Sep-2009 -
Data Types & SubTypes 11gR2 06-Jun-2010 -
Database 11gR1 22-Feb-2009 -
Database Links 11gR2 01-Apr-2010 -
Date Functions 11gR2 14-Apr-2010 -
DBA Best Practice Guidelines 11gR2 30-Aug-2010
DBMSOBJG 11gR2 02-Sep-2009 -
DBMS_ADDM 11gR2 02-Sep-2009 -
DBMS_ADVANCED_REWRITE 11gR2 20-Nov-2009 -
DBMS_ADVISOR 11gR2 23-Dec-2009 -
DBMS_ALERT 11gR2 07-Feb-2010 -
DBMS_AMD 11gR2 02-Sep-2009 -
DBMS_APPLICATION_INFO 11gR2 18-Jun-2010 -
DBMS_APPLY_ADM 11gR2 02-Sep-2009 partial
DBMS_AQ 11gR2 02-Sep-2009 -
DBMS_AQADM 11gR2 04-Dec-2009 -
DBMS_AQELM 11gR2 02-Sep-2009 -
DBMS_ASSERT 11gR2 02-Sep-2009 -
DBMS_ASYNCRPC_PUSH 11gR2 14-Oct-2009 -
DBMS_AUDIT_MGMT 11gR2 07-Mar-2010 -
DBMS_AUTO_TASK 11gR2 02-Sep-2009 -
DBMS_AUTO_TASK_ADMIN 11gR2 05-Jul-2010 -
DBMS_AUTO_TASK_EXPORT 11gR2 02-Sep-2009 -
DBMS_AUTO_TASK_IMMEDIATE 11gR2 02-Sep-2009 -
DBMS_AW 11gR2 02-Sep-2009 -
DBMS_AW_STATS 11gR2 02-Sep-2009 -
DBMS_AWR_REPORT_LAYOUT 11gR2 04-Sep-2009 -
DBMS_BACKUP_RESTORE 11gR2 05-Jul-2010 -
DBMS_CACHEUTIL 11gR2 04-Sep-2009 -
DBMS_CAPTURE_ADM 11gR2 02-Sep-2009 -
DBMS_CDC_PUBLISH 11gR2 02-Sep-2009 -
DBMS_CDC_SUBSCRIBE 11gR2 02-Sep-2009 -
DBMS_CDC_UTILITY 11gR2 22-Mar-2010 -
DBMS_CHANGE_NOTIFICATION 11gR2 03-Feb-2010 -
DBMS_CLUSTDB 11gR2 02-Sep-2009 -
DBMS_COMPARISON 11gR2 01-Mar-2010 -
DBMS_COMPRESSION 11gR2 14-Jun-2010 -
DBMS_CONNECTION_POOL 11gR2 02-Sep-2009 -
DBMS_CQ_NOTIFICATIONS 11gR2 02-Sep-2009 -
DBMS_CRYPTO 11gR2 20-Mar-2010 -
DBMS_CRYPTO_TOOLKIT_TYPES 11gR2 02-Sep-2009 -
DBMS_CSX_ADMIN 11gR2 07-Nov-2009 -
DBMS_CUBE 11gR2 16-Nov-2009 -
DBMS_CUBE_LOG 11gR2 16-Nov-2009 -
DBMS_DATAPUMP 11gR2 24-Oct-2009 -
DBMS_DBFS_CONTENT_ADMIN 11gR2 02-Aug-2010
DBMS_DBFS_SFS 11gR2 15-Mar-2010 -
DBMS_DBFS_SFS_ADMIN 11gR2 15-Mar-2010 -
DBMS_DBLINK 11gR2 02-Sep-2009 -
DBMS_DBVERIFY 11gR2 02-Sep-2009 -
DBMS_DB_VERSION 11gR2 09-Sep-2009 -
DBMS_DDL 11gR2 02-Aug-2010
DBMS_DDL_INTERNAL 11gR2 02-Sep-2009 -
DBMS_DEBUG 11gR2 12-Apr-2010 -
DBMS_DEBUG_JDWP 11gR2 02-Sep-2009 -
DBMS_DEBUG_JDWP_CUSTOM 11gR2 02-Sep-2009 -
DBMS_DEFER_SYS 11gR2 22-Dec-2009 -
DBMS_DESCRIBE 11gR2 02-Sep-2009 -
DBMS_DG 11gR2 02-Sep-2009 -
DBMS_DIMENSION 11gR2 02-Sep-2009 -
DBMS_DISTRIBUTED_TRUST_ADMIN 11gR2 02-Sep-2009 -
DBMS_DRS 11gR2 03-Aug-2010
DBMS_DST 11gR2 14-Apr-2010 -
DBMS_EDITIONS_UTILITIES 11gR2 02-Sep-2009 -
DBMS_EPG 11gR2 02-Sep-2009 -
DBMS_ERRLOG 11gR2 26-May-2010 -
DBMS_EXPFIL 11gR2 02-Sep-2009 -
DBMS_EXTENDED_TTS_CHECKS 11gR2 14-Jun-2010 -
DBMS_FBT 11gR2 02-Sep-2009 -
DBMS_FEATURE Procedures 11gR2 02-Sep-2009 -
DBMS_FEATURE_USAGE 11gR2 02-Sep-2009 -
DBMS_FEATURE_USAGE_REPORT 11gR2 02-Sep-2009 -
DBMS_FGA 11gR2 02-Sep-2009 -
DBMS_FILE_TRANSFER 11gR2 14-Dec-2009 -
DBMS_FLASHBACK 11gR2 07-Jul-2010 -
DBMS_FLASHBACK_ARCHIVE 11gR2 24-Oct-2009 -
DBMS_FREQUENT_ITEMSET 11gR2 14-Apr-2010 -
DBMS_HA_ALERTS 11gR2 02-Sep-2009 -
DBMS_HA_ALERTS_PRVT 11gR2 02-Sep-2009 -
DBMS_HM 11gR2 02-Sep-2009 -
DBMS_HPROF 11gR2 21-Feb-2010 -
DBMS_I_INDEX_UTL 11gR2 14-Jun-2010 -
DBMS_INDEX_UTL 11gR2 02-Sep-2009 -
DBMS_INDEXING 11gR2 02-Sep-2009 -
DBMS_IOT 11gR2 02-Sep-2009 -
DBMS_IR 11gR2 02-Sep-2009 -
DBMS_JAVA 11gR2 14-Jun-2010 -
DBMS_JAVA_DUMP 11gR2 02-Sep-2009 -
DBMS_JOB 11gR2 02-Sep-2009 See DBMS_SCHEDULER too
DBMS_LCR 11gR2 02-Sep-2009 -
DBMS_LDAP 11gR2 18-Jun-2010 -
DBMS_LOB 11gR2 18-Nov-2009 -
DBMS_LOBUTIL 11gR2 02-Sep-2009 -
DBMS_LOCK 11gR2 02-Sep-2009 -
DBMS_LOGMNR 11gR2 14-Jun-2010 -
DBMS_LOGMNR_D 11gR2 02-Sep-2009 -
DBMS_LOGSTDBY 11gR2 21-Feb-2010 -
DBMS_MANAGEMENT_PACKS 11gR2 02-Sep-2009 -
DBMS_METADATA 11gR2 14-Jun-2010 -
DBMS_METADATA_BUILD 11gR2 02-Sep-2009 -
DBMS_METADATA_DIFF 11gR2 05-Aug-2010
DBMS_METADATA_UTIL 11gR2 14-Jun-2010 -
DBMS_MONITOR 11gR2 02-Sep-2009 -
DBMS_MVIEW 11gR2 02-Sep-2009 -
DBMS_NETWORK_ACL_ADMIN 11gR2 19-Jun-2010 -
DBMS_NETWORK_ACL_UTILITY 11gR2 02-Sep-2009 -
DBMS_OBFUSCATION_TOOLKIT - - Deprecated See DBMS_CRYPTO
DBMS_OBJECTS_UTILS 11gR2 02-Sep-2009 -
DBMS_ODCI 11gR2 14-Apr-2010 -
DBMS_OUTLN 11gR2 02-Sep-2009 -
DBMS_OUTLN_EDIT 11gR2 02-Sep-2009 -
DBMS_OUTPUT 11gR2 02-Sep-2009 -
DBMS_PARALLEL_EXECUTE 11gR2 21-Mar-2010 -
DBMS_PARALLEL_EXECUTE_INTERNAL 11gR2 04-Sep-2009 -
DBMS_PCLXUTIL 11gR2 02-Sep-2009 -
DBMS_PIPE 11gR2 07-Feb-2010 -
DBMS_PLUGTS 11gR2 21-Mar-2010 -
DBMS_PLUGTSP 11gR2 22-Mar-2010  
DBMS_PREDICTIVE_ANALYTICS 11gR2 02-Sep-2009  
DBMS_PREPROCESSOR 11gR2 02-Sep-2009 -
DBMS_PROFILER 11gR2 02-Sep-2009 -
DBMS_PROPAGATION_ADM 11gR2 02-Sep-2009 -
DBMS_RANDOM 11gR2 02-Sep-2009 -
DBMS_RCVCAT 11gR2 14-Dec-2009 -
DBMS_RCVMAN 11gR2 09-Aug-2010
DBMS_RECTIFIER_DIFF 11gR2 02-Sep-2009 -
DBMS_RECTIFIER_FRIENDS 11gR2 02-Sep-2009 -
DBMS_REDEFINITION 11gR2 21-Feb-2010 -
DBMS_REFRESH 11gR2 02-Sep-2009 -
DBMS_REGISTRY 11gR2 09-Aug-2010
DBMS_REGISTRY_SERVER 11gR2 02-Sep-2009 -
DBMS_REGXDB 11gR2 14-Jun-2010 -
DBMS_REPAIR 11gR2 26-Feb-2010 -
DBMS_REPORT 11gR2 02-Sep-2009 -
DBMS_REPUTIL 11gR2 02-Sep-2009 -
DBMS_RESCONFIG 11gR2 25-Apr-2010 -
DBMS_RESOURCE_MANAGER 11gR2 30-Aug-2010
DBMS_RESOURCE_MANAGER_PRIVS 11gR2 02-Sep-2009 -
DBMS_RESULT_CACHE 11gR2 14-Apr-2010 -
DBMS_RESUMABLE 11gR2 02-Sep-2009 -
DBMS_RLS 11gR2 02-Sep-2009 -
DBMS_ROWID 11gR2 02-Sep-2009 -
DBMS_SCHEDULER 11gR2 04-Jul-2010 -
DBMS_SCHEMA_COPY 10gR2 12-Aug-2009 Dropped from 11.1.0.6
DBMS_SERVER_ALERT 11gR2 03-Sep-2009 -
DBMS_SERVER_TRACE 11gR2 03-Sep-2009 -
DBMS_SERVICE 11gR2 30-Jun-2010 -
DBMS_SESSION 11gR2 03-Sep-2009 -
DBMS_SESSION_STATE 11gR2 26-Sep-2009 -
DBMS_SHARED_POOL 11gR2 14-Jun-2010 -
DBMS_SNAPSHOT 11gR2 03-Sep-2009 -
DBMS_SPACE 11gR2 14-Jun-2010 -
DBMS_SPACE_ADMIN 11gR2 06-Jul-2010 -
DBMS_SPM 11gR2 21-Nov-2009 -
DBMS_SQL 11gR2 27-Jul-2010 -
DBMS_SQLDIAG 11gR2 24-Oct-2009 -
DBMS_SQLHASH 11gR2 03-Sep-2009 -
DBMS_SQLJTYPE 11gR2 14-Jun-2010 -
DBMS_SQLPA 11gR2 26-Dec-2009 -
DBMS_SQLPLUS_SCRIPT 11gR2 03-Sep-2009 -
DBMS_SQLTUNE 11gR2 14-Jun-2010 -
DBMS_STANDARD 11gR2 21-Feb-2010 -
DBMS_STAT_FUNCS 11gR2 14-Apr-2010 -
DBMS_STATS 11gR2 14-Aug-2010
DBMS_STORAGE_MAP 11gR2 03-Sep-2009 -
DBMS_STREAMS 11gR2 03-Sep-2009 -
DBMS_STREAMS_ADM 11gR2 23-Nov-2009 -
DBMS_STREAMS_AUTH 11gR2 03-Sep-2009 -
DBMS_SUMVDM 11gR2 24-Aug-2010
DBMS_SUPPORT 11gR2 03-Sep-2009 -
DBMS_SYS_ERROR 11gR2 16-Mar-2010 -
DBMS_SYSTEM 11gR2 03-Feb-2010 -
DBMS_TDB 11gR2 21-Mar-2010 -
DBMS_TRACE 11gR2 03-Sep-2009 -
DBMS_TRANSACTION 11gR2 03-Sep-2009 -
DBMS_TRANSFORM 11gR2 03-Sep-2009 -
DBMS_TTS 11gR2 21-Mar-2010 -
DBMS_TYPES 11gR2 03-Sep-2009 -
DBMS_UNDO_ADV 11gR2 03-Sep-2009 -
DBMS_UTILITY 11gR2 21-Mar-2010 -
DBMS_WARNING 11gR2 03-Sep-2009 -
DBMS_WARNING_INTERNAL 11gR2 14-Jun-2010 -
DBMS_WLM 11gR2 04-Sep-2009 -
DBMS_WM Synonym 11gR2 20-Sep-2009 -
DBMS_WORKLOAD_CAPTURE 11gR2 25-Feb-2010 -
DBMS_WORKLOAD_REPLAY 11gR2 25-Feb-2010 -
DBMS_WORKLOAD_REPOSITORY 11gR2 04-Sep-2009 -
DBMS_XA 11gR2 04-Sep-2009 -
DBMS_XDB 11gR2 14-Dec-2009  
DBMS_XDBUTIL_INT 11gR2 04-Sep-2009 -
DBMS_XMLGEN 11gR2 04-Sep-2009 -
DBMS_XMLSCHEMA 11gR2 04-Sep-2009 -
DBMS_XPLAN 11gR2 01-Nov-2009 -
DBMS_XQUERY 11gR2 01-Mar-2010 -
DBMS_XSLPROCESSOR 11gR2 12-Dec-2009 -
DBMS_XSTREAM_ADM 11gR2 01-Nov-2009 -
DBMS_XSTREAM_ADM_UTL 11gR2 01-Nov-2009 -
DBMS_ZHELP 11gR2 14-Jun-2010 -
DBMS_ZHELP_IR 11gR2 04-Sep-2009 -
DBV (database verify) 11gR2 10-Sep-2009 -
DCL Statements 11gR2 10-Sep-2009 -
DDL Event Triggers 11gR2 21-Feb-2010 -
DDL Statements 11gR2 20-Dec-2009 -
Deadlocks 11gR2 10-Sep-2009 -
DECODE Function 11gR2 21-Apr-2009 -
Deferrable Constraints 11gR2 09-Sep-2009 -
Delete Statement 11gR2 10-Sep-2009 -
Descending Indexes 11gR2 22-Aug-2010
DICOM 11gR1 17-Jun-2010 -
Dimensions 11gR2 10-Sep-2009 -
Directories 11gR2 01-Nov-2009 -
Disassociate Statistics 11gR2 10-Sep-2009 -
DIUTIL 11gR2 10-Sep-2009 -
DML Statements 11gR2 10-Sep-2009 -
Dumping Oracle 11gR2 20-Jul-2010 -
Dynamic Performance Views 11gR2 15-Jun-2010 -
E-Business Suite 11.5.10 29-Sep-2007 -
Edition Based Redefinition 11gR2 21-Mar-2010 -
Editioning Demo 1: Editions 11gR2 15-Apr-2010 -
Editioning Demo 2: Editioning Views 11gR2 21-Mar-2010 -
Editioning Demo 3: Crossedition Triggers 11gR2 02-Mar-2010 -
Editioning Demo 4: Online Table Update 11gR2 22-Mar-2010 -
Editioning Demo 5: Invisible Indexes 11gR2 09-May-2010 -
Editioning Views 11gR2 24-Feb-2010 -
Editions 11gR2 12-Mar-2010 -
Encrypted Tablespaces 11gR2 28-Sep-2009 -
Environment Variables 11gR2 11-Sep-2009 -
Errors 11gR2 11-Sep-2009 -
Events 11gR2 28-Aug-2010
Exadata 11gR2 24-Dec-2009 -
Exception Handling 11gR2 16-Mar-2010 -
Excluded Nodes 11gR2 27-Sep-2008 -
Exists 11gR2 11-Sep-2009 -
Explain Plan 11gR2 21-Jan-2010 -
Export 11gR2 11-Sep-2009 -
Expression Filtering 11gR2 02-Sep-2009 -
Extensible Optimizer 11gR2 03-Jun-2010 -
External Tables 11gR2 21-Mar-2010 -
Files Of Interest 11gR2 20-Mar-2010 -
Fine Grained Access Control (FGAC) 11gR2 02-Sep-2009 -
Fine Grained Access Control Demo 11gR1 17-Nov-2008 -
Fine Grained Auditing (FGA) 11gR2 02-Sep-2009 -
Fine Grained Dependency Tracking 11gR2 23-Nov-2009 -
FIPS Flagging 11gR2 11-Sep-2009 -
Flashback 11gR2 11-Sep-2009 -
Flashback Archive 11gR2 14-Jun-2010 -
Flashback Database 11gR2 11-Sep-2009 -
Flashback Drop 11gR2 11-Sep-2009 -
Flashback Query 11gR2 14-Jun-2010 -
Flashback Table 11gR2 11-Sep-2009 -
Flashback Transaction 11gR2 28-Jun-2010 -
Flashback Version 11gR2 11-Sep-2009 -
FOLLOWS Clause (Triggers) 11gR2 28-Feb-2010 -
FOR LOOPS 11gR2 01-Sep-2009 -
FOR UPDATE 11gR2 10-Sep-2009 -
FORALL Statements 11gR2 02-Jun-2010 -
Foreign Key Constraint 11gR2 09-Sep-2009 -
FORMs Developer 10.1.2.0.2 16-Aug-2009 -
Function Based Indexes 11gR2 22-Aug-2010
Functions: Deterministic 11gR2 14-Jun-2010 -
Functions: Miscellaneous 11gR2 09-Nov-2009 -
Functions: Owned by SYS 11gR2 23-Jul-2010 -
Functions: User Defined 11gR2 14-Jun-2010 -
Fusion MiddleWare Application Server 10.1.2.0.2 02-Jan-2007 -
Fusion MiddleWare Application Server 10.1.3.0.0 02-Jan-2007 -
Global Hints 11gR2 24-Jul-2010 -
Global Partitioned Indexes 11gR2 08-Jun-2010 -
Global Temporary Tables 11gR2 11-Sep-2009 -
Globalization Toolkit 11gR2 04-Sep-2009 -
GLOGIN.SQL 11gR2 11-Sep-2009 -
Grid Control 10.2.0.4 17-Sep-2009 -
GROUP BY Clauses 11gR2 14-Apr-2010 -
GROUP ID 11gR2 10-Nov-2009 -
GROUPING SETS 11gR2 10-Nov-2009 -
Guaranteed Restore Point 11gR2 16-Jul-2010 -
GV$ Views 11gR2 28-Sep-2009 -
Hash Partitioning 11gR2 08-Jun-2010 -
HAVING Clauses 11gR2 11-Sep-2009 -
Heap Tables 11gR2 08-Jun-2010 -
High Availability Technologies 11gR2 14-Mar-2010 -
Hints 11gR2 24-Jul-2010 -
Histograms, Frequency 11gR2 02-Feb-2010 -
Histograms, Height Balanced 11gR2 02-Feb-2010 -
Host Environment 11gR2 12-Sep-2009 -
HTP 11gR2 12-Sep-2009 -
Hybrid Columnar Compression 11gR2 15-Oct-2009 -
IF Statements 11gR2 26-Feb-2010 -
Import 11gR2 04-Aug-2009 -
Index Scans 11gR2 01-Jul-2010 -
Indexes 11gR2 22-Aug-2010
Index Organized Tables (IOT) 11gR2 15-Sep-2009 -
Init SID Dot Ora 11gR2 06-Oct-2009 -
Inline Views 11gR2 15-Sep-2009 -
Insert Statements 11gR2 03-Apr-2010 -
Instead-Of Triggers 11gR2 15-Sep-2009 -
Instring Function 11gR2 10-Nov-2009 -
Intermedia Audio 11gR2 01-Sep-2010
Intermedia Video 11gR2 01-Sep-2010
Interval 11gR2 09-Nov-2009 -
Interval Partitioning 11gR2 08-Jun-2010 -
Interview Questions 11gR2 20-Jul-2010 -
Invisible Indexes 11gR2 22-Aug-2010
Invited Nodes 11gR2 27-Sep-2008 -
IS NOT OF TYPE 11gR2 11-Sep-2009 -
IS OF ONLY 11gR2 11-Sep-2009 -
IS OF TYPE 11gR2 11-Sep-2009 -
Java Functions & Procedures 11gR2 28-Dec-2009 -
Joins 11gR2 14-Jun-2010 -
Keep Pool 11gR2 15-Sep-2009 -
Killing Sessions 11gR2 20-Aug-2010
Large Objects 11gR2 15-Dec-2009 -
LCR$_XML_SCHEMA 11gR2 15-Sep-2009 -
Licensing 10gR2 30-Sep-2006 -
Licensing 11gR1 08-Feb-2008 -
Licensing 11gR2 21-Nov-2009 -
Linux Installation for Oracle RDBMS (10.2.0.1.0) 10gR2 17-Oct-2009 -
Linux Installation for Oracle RDBMS (11.1.0.6.0) 11gR1 17-Oct-2009 -
Linux Installation for Oracle RDBMS (11.2.0.1.0) 11gR2 12-Apr-2010 -
List Partitioning 11gR2 08-Jun-2010 -
Listener 11gR2 05-Jul-2010 -
LOB Compression 11gR2 15-Sep-2009 -
LOBs 11gR2 05-Jul-2010 -
Local Partitioned Indexes 11gR2 08-Jun-2010 -
Locks 11gR2 14-Jun-2010 -
Log Files 11gR2 15-Sep-2009 -
Logical Standby 11gR2 18-Jun-2010 -
Log Miner 11gR2 02-Sep-2009 -
LONG To CLOB 11gR2 23-Jul-2010 -
Loops 11gR2 26-Feb-2010 -
LT Built-in Package 11gR2 04-Sep-2009 -
Materialized Views 11gR2 16-Jun-2010 -
Materialized View Logs 11gR2 16-Jun-2010 -
Merge Statement 11gR2 10-Sep-2009 -
Metalink - 21-Nov-2009 -
MGMT_USER 11gR2 21-Nov-2009 -
Microsoft SQL Server 2005/8 Comparison - 07-Aug-2009 -
Microsoft Vista Enterprise and Oracle 10gR2 21-Apr-2007 -
Model Clause 10g 09-Dec-2006 -
Multidimensional Collections 11gR2 21-Jul-2010 -
Multimedia Audio 11gR2 01-Sep-2010
Multimedia Video 11gR2 01-Sep-2010
Multiset 11gR2 01-Sep-2009 -
Multiversion Concurrency Control (MVCC) 11gR2 15-Sep-2009 -
Mutating Trigger 11gR2 28-Feb-2010 -
Native Compilation 11gR2 15-Sep-2009 -
Native Dynamic SQL (NDS) 11gR2 31-Mar-2010 -
Nested Loops 11gR2 26-Feb-2010 -
Nested Tables 11gR2 15-Sep-2009 -
Nested Table Constraints 11gR2 15-Sep-2009 -
NetApp Filer Head - 10-Oct-2008 -
Net Services 11gR1 13-Nov-2008 -
Network Appliance Filer Management - 10-Oct-2008 -
NID (change internal database identifier) 11gR2 10-Sep-2009 -
No Segment Indexes 11gR2 22-Aug-2010
NOCOPY 11gR2 15-Sep-2009 -
Normalization - 28-May-2007 -
NOWAIT 11gR2 10-Sep-2009 -
Numeric Functions 11gR2 26-Feb-2010 -
NULL 11gR2 16-Sep-2009 -
NULL Pruning 11gR2 16-Sep-2009 -
Object Privileges 11gR2 09-Dec-2009 -
Object-Relational Views 11gR2 14-Nov-2009 -
Object Tables 11gR2 15-Sep-2009 See Nested Tables and Varrays
OBJECT_ID 11gR2 08-Sep-2009 -
OLAP Functions 11gR2 09-Jul-2010 -
OPEN FOR 11gR2 16-Sep-2009 -
Opatch 11gR2 10-Sep-2009 -
Operators: Built-in 11gR2 13-Nov-2009 -
Operators: User Defined 11gR2 07-Apr-2010 -
ORA_HASH 11gR2 16-Sep-2009 -
ORA_NAME_LIST_T 11gR2 18-Nov-2009 -
ORA_ROWSCN 11gR2 02-Sep-2009 -
Oracle Support Services - 21-Nov-2009 -
Oracle Universal Installer 11gR2 25-Dec-2009 -
ORADEBUG 11gR2 30-Dec-2009 -
ORADIM 11gR2 16-Sep-2009 -
ORAPWD 11gR2 10-Sep-2009 -
ORASTACK 11gR2 10-Sep-2009 -
ORD_DICOM 11gR2 10-Oct-2009 -
ORDER BY Clause 11gR2 10-Nov-2009 -
Outlines 11gR2 22-Nov-2009 -
OUTLN_EDIT_PKG 11gR2 16-Sep-2009 -
OUTLN_PKG 11gR2 16-Sep-2009 -
OWA 11gR2 16-Sep-2009 -
OWA_CUSTOM 11gR2 16-Sep-2009 -
OWA_CX 11gR2 16-Sep-2009 -
OWA_OPT_LOCK 11gR2 16-Sep-2009 -
OWA_SEC 11gR2 16-Sep-2009 -
OWA_TEXT 11gR2 16-Sep-2009 -
OWA_UTIL 11gR2 05-Apr-2010 -
Packages: User Defined 11gR2 02-Sep-2009 -
Parent Correlation Name 11gR2 15-Sep-2009 -
Partitioning (tables and indexes) 11gR2 08-Jun-2010 -
Partitioning by Reference 11gR2 08-Jun-2010 -
Partition by System 11gR2 08-Jun-2010 -
Partitioning Elimination Demo 11gR2 08-Jun-2010 -
Partitioning Pruning Demo 11gR2 08-Jun-2010 -
Password File 11gR2 10-Sep-2009 -
Patches For Upgrading Your Database All Ver. 19-Jun-2010 -
Physical Standby 11gR2 18-Jun-2010 -
Pipelined Table Functions 11gR2 07-Apr-2010 -
Pivot 11gR2 01-Sep-2009 -
PLITBLM 11gR2 07-Jun-2010 -
PLSHPROF 11gR2 06-Oct-2009 -
PLSQL_CCFLAGS 11gR2 16-Sep-2009 -
PL/Scope 11gR1 14-Jun-2010 -
PL/SQL Object Settings 11gR2 16-Sep-2009 -
PL/SQL Warnings 11gR2 16-Sep-2009 -
PRAGMAS 11gR2 08-Nov-2009 -
PRAGMA Autonomous_Transaction 11gR2 16-Sep-2009 -
PRAGMA Exception_Init 11gR2 06-Oct-2009 -
PRAGMA Inline 11gR2 16-Sep-2009 -
PRAGMA Serially Reusable 11gR2 16-Sep-2009 -
PRAGMA Suplemental Log Data 11gR2 16-Sep-2009 -
PRECEDES Clause (Triggers) 11gR2 02-Mar-2010 -
Predefined Inquiry Directives 11gR2 09-Sep-2009 -
Primary Key Constraint 11gR2 09-Sep-2009 -
Procedures 11gR2 14-Jun-2010 -
Processes 11gR2 12-Jul-2010  
Product User Profiles 11gR2 16-Sep-2009 -
Profiles 11gR2 16-Sep-2009 -
PROTOCOL.ORA 11gR2 27-Sep-2008 -
PRVT_COMPRESSION 11gR2 14-Jun-2010 -
Pseudo Columns 11gR2 20-Jan-2010 -
Public Synonyms 11gR2 14-Mar-2010 -
Purge Recyclebin 11gR2 17-Sep-2009 -
Purge Table 11gR2 17-Sep-2009 -
PuTTY 11gR2 12-Aug-2010
Quote Delimiters 11gR2 11-Sep-2009 -
RAC 11gR1 30-Aug-2010
RAID 11gR2 17-Sep-2009 -
RAISE 11gR2 11-Sep-2009 -
RAISE_APPLICATION_ERROR 11gR2 11-Sep-2009 -
Range Partitioning 11gR2 08-Jun-2010 -
Rank 11gR2 17-Sep-2009 -
RDA 11gR2 17-Sep-2009 -
Read Only Tables 11gR2 17-Sep-2009 -
Real Application Clusters 11gR1 30-Aug-2010
Recycle Bin 11gR2 17-Sep-2009 -
Recycle Pool 11gR2 17-Sep-2009 -
Redo 11gR2 17-Sep-2009 -
Ref Cursors 11gR2 16-Sep-2009 -
Referential Constraint 11gR2 09-Sep-2009 -
Referential Partition 11gR2 08-Jun-2010 -
Regular Expressions 11gR2 02-Sep-2010
Remote Diagnostic Agent 11gR2 17-Sep-2009 -
Replace Built-in Function 11gR2 17-Sep-2009 See also REGEXP_REPLACE
Restore Point 11gR2 16-Jul-2010 -
Result Cache (SQL) 11gR2 07-Oct-2009 -
Result Cache (PL/SQL) 11gR2 07-Oct-2009 -
Resumable Transactions 11gR2 02-Sep-2009 -
Reverse Key Indexes 11gR2 22-Aug-2010
Rewrite Equivalence 11gR2 02-Sep-2009 -
RMAN 11gR2 11-Jul-2010 -
RMAN Demo 11gR2 14-Jun-2010 -
Roles 11gR2 17-Sep-2009 -
Rollback 11gR2 01-Sep-2009 -
Rollup 11gR2 10-Nov-2009 -
ROWDEPENDENCIES 11gR2 08-Sep-2009 -
ROWID 11gR2 08-Sep-2009 -
Row Level Security 11gR2 02-Sep-2009 -
ROWNUM 11gR2 08-Sep-2009 -
Based Optimizer (RBO) - 16-Apr-2004 Deprecated
Sample Clause 11gR2 10-Oct-2009 -
Savepoint 11gR2 01-Sep-2009 -
Schema 11gR2 09-Sep-2009 -
SecureFiles 11gR2 18-Sep-2009 -
Security 11gR2 18-Sep-2009 -
Seed Clause 11gR2 10-Oct-2009 -
Segments 11gR2 11-Aug-2010
Select Statement 11gR2 14-Feb-2010 -
Select Into Statement 11gR2 10-Oct-2009 -
Semantic Effect Hints 11gR2 03-Jan-2010 -
Sequences 11gR2 21-Feb-2010 -
Services 11gR2 18-Sep-2009 -
Sessions 11gR2 15-Feb-2010 -
Set Operators 11gR2 01-Sep-2009 -
SET TRANSACTION 11gR2 01-Sep-2009 -
SHOW 11gR2 20-Sep-2009 -
SKIP LOCKED 11gR2 10-Sep-2009 -
SLEEP 11gR2 20-Sep-2009 -
Snapshots 11gR2 07-Sep-2009 -
Data Guard Snapshot Standby 11gR2 18-Jun-2010 -
Sorted Hash Clusters 11gR2 09-Sep-2009 -
Soundex 11gR2 11-Sep-2009 -
SPFile 11gR2 06-Oct-2009 -
SQL Injection 11gR2 15-Sep-2009 -
SQL*Loader 11gR2 28-Jan-2010 -
SQL*Plus 11gR2 08-Jul-2010 -
SQL*Plus Windows 11gR2 12-Apr-2010 -
SQLNET.ORA 11gR1 27-Sep-2008 -
SQL_TXT 11gR2 18-Nov-2009 -
Standard 11gR2 13-Nov-2009 -
Starting & Stopping The Database 11gR2 20-Sep-2009 -
Startup Parameters 11gR2 23-Aug-2010
Stored Outlines 11gR2 06-Mar-2010 -
Stored Procedures 11gR2 23-Feb-2010 -
Storage - 17-Sep-2009 -
Streams Demo 1 11gR2 08-Aug-2010
Streams Demo 2 11gR2 08-Aug-2010
Streams Demo 3 11gR2 08-Aug-2010
String Functions 11gR2 28-Jul-2010 -
Subqueries 11gR2 11-Sep-2009 -
Subquery Factoring 11gR2 01-Nov-2009 -
Substring Function 11gR2 10-Nov-2009 See also REGEXP_SUBSTR
Subtypes 11gR2 07-Jun-2010 -
Synonyms 11gR2 14-Mar-2010 -
SYS_CONTEXT Built-in Function 11gR2 23-Jul-2010 -
SYS_GUID 11gR2 11-Sep-2009 -
SYS_OP_COMBINED_HASH 11gR2 11-Sep-2009 -
SYS_OP_DESCEND 11gR2 11-Sep-2009 -
SYS_OP_DISTINCT 11gR2 11-Sep-2009 -
SYS_OP_GUID 11gR2 11-Sep-2009 -
SYS_OP_LBID 11gR2 10-Jun-2010 -
SYS_OP_MAP_NONNULL 11gR2 11-Sep-2009 -
SYS_OP_RAWTONUM 11gR2 11-Sep-2009 -
SYS_OP_RPB 11gR2 11-Sep-2009 -
SYS_OP_TOSETID 11gR2 11-Sep-2009 -
SYS_TYPEID 11gR2 11-Sep-2009 -
System 11gR2 20-Sep-2009 -
System Events 11gR2 20-Sep-2009 -
System Event Triggers 11gR2 20-Sep-2009 -
System Privileges 11gR2 16-Feb-2010 -
System Statistics 11gR2 20-Sep-2009 -
Table Collection Expression 11gR2 20-Sep-2009 -
Tables 11gR2 08-Jun-2010 -
Table Triggers 11gR2 28-Feb-2010 -
Tablespaces 11gR2 01-Feb-2010 -
Tablespace Groups 11gR2 20-Sep-2009 -
Temporary Tablespaces 11gR2 20-Sep-2009 -
Timestamp 11gR2 09-Nov-2009 -
Time Zones 11gR2 20-Sep-2009 -
TKPROF 11gR2 28-Aug-2010
Total Recall 11gR2 11-Sep-2009 -
Trace File Identifier 11gR2 06-Oct-2009 -
Tracing 11gR2 28-Aug-2010
Transaction Backout 11gR2 17-Sep-2009 -
Transactions 11gR2 22-Feb-2010 -
Transitive Closure 11gR2 21-Jan-2010 -
Translate Built-in Function 11gR2 17-Sep-2009 -
Transparent Data Encryption 11gR2 14-Jun-2010 -
Transportable Tablespaces 11gR2 14-Jun-2010 -
Truncate (Tables & Partitions) 11gR2 29-Jul-2010
Tuning 11gR2 30-Aug-2010
Types 11gR2 07-Jun-2010 -
Undo Compression 11gR2 19-Dec-2009 -
Undo Tablespace 11gR2 20-Sep-2009 -
Undocumented Oracle 11gR2 11-Jul-2010 -
Uninstall Oracle 11gR2 12-Jul-2010 -
UNIX / vi - 20-Jun-2010 -
UNION 11gR2 01-Sep-2009 -
UNION ALL 11gR2 01-Sep-2009 -
Unique Constraint 11gR2 09-Sep-2009 -
Unpivot 11gR2 01-Sep-2009 -
Update Statement 11gR2 20-Sep-2009 -
USERENV 11gR2 20-Sep-2009 -
Users 11gR2 18-May-2010 -
USER_LOCK 11gR2 04-Sep-2009 -
Utilities 11gR2 24-May-2010 -
UTL_COLL 11gR2 04-Sep-2009 -
UTL_COMPRESS 11gR2 04-Sep-2009 -
UTL_ENCODE 11gR2 04-Sep-2009 -
UTL_FILE 11gR2 25-Sep-2009 -
UTL_GDK 11gR2 04-Sep-2009 -
UTL_HTTP 11gR2 04-Sep-2009 -
UTL_I18N 11gR2 04-Sep-2009 -
UTL_IDENT 11gR2 24-Oct-2009 -
UTL_INADDR 11gR2 04-Sep-2009 -
UTL_LMS 11gR2 04-Sep-2009 -
UTL_MAIL 11gR2 04-Sep-2009 -
UTL_MATCH 11gR2 04-Sep-2009 -
UTL_NLA 11gR2 10-Aug-2010
UTL_PG 11gR2 08-Nov-2009 -
UTL_RAW 11gR2 15-Jul-2010 -
UTL_RECOMP 11gR2 26-Jul-2010 -
UTL_REF 11gR2 04-Sep-2009 -
UTL_SMTP 11gR2 26-Apr-2010 -
UTL_SPADV 11gR2 04-Sep-2009 -
UTL_SYS_COMPRESS 11gR2 04-Sep-2009 -
UTL_TCP 11gR2 15-Aug-2010
UTL_URL 11gR2 04-Sep-2009 -
UTL_XML 11gR2 31-Oct-2009 -
Variables 11gR2 10-Feb-2010 -
VARRAYS 11gR2 06-Jul-2010 -
VERSIONS BETWEEN 11gR2 08-Sep-2009 -
Views 11gR2 24-Feb-2010 -
Virtual Columns 11gR2 12-Sep-2009 -
Virtual Column Partitioning 11gR2 08-Jun-2010 -
Virtual Indexes 11gR2 22-Aug-2010
Virtual Private Database 11gR2 02-Sep-2009 -
V$ Views 11gR2 28-Sep-2009 -
WAIT (WITH WAIT, WITH NOWAIT) 11gR2 10-Sep-2009 -
Wallet 11gR2 20-May-2010 -
Where Clause 11gR2 20-Sep-2009 -
Wildcards 11gR2 20-Sep-2009 -
WITH Clause 11gR2 01-Nov-2009 -
WM_CONCAT 11gR2 07-Apr-2010 -
WM_CONTAINS 11gR2 07-Apr-2010 -
WM_EQUALS 11gR2 07-Apr-2010 -
WM_GREATERTHAN 11gR2 07-Apr-2010 -
WM_INTERSECTION 11gR2 07-Apr-2010 -
WM_LDIFF 11gR2 07-Apr-2010 -
WM_LESSTHAN 11gR2 07-Apr-2010 -
WM_MEETS 11gR2 07-Apr-2010 -
WM_OVERLAPS 11gR2 07-Apr-2010 -
WM_RDIFF 11gR2 07-Apr-2010 -
Workspace Manager 11gR2 20-Sep-2009 -
WPG_DOCLOAD 11gR2 04-Sep-2009 -
Wrap 11gR2 10-Sep-2009 -
Write a CLOB to File 11gR2 14-Nov-2009 -
WWV_FLOW_VAL 11gR2 20-Sep-2009 -
X$ Structures 11gR2 22-Dec-2009 Still under construction
XMLDATA Pseudocolumn 11gR2 08-Sep-2009 -
XML Functions 11gR2 10-Jul-2010 -
XMLQuery 11gR2 28-Mar-2010 -
XMLTable 11gR2 08-Sep-2009 -
XMLTYPE 11gR2 08-Sep-2009 -
XML Tables 11gR2 08-Sep-2009 -
XML SCHEMA_NAME_PRESENT 11gR2 08-Sep-2009 -
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: