Morgan's Library
 
Morgan's Library has become one of the web's most important resources expanding, over the years, to more than 651 pages accessed with more than 1.1 million page, from more than 180 countries, each month.
To keep this resource available to the community we ask you to 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.
Please become a contributing member by donating $25 for 2010. We sincerely thank all of you that have helped make this site possible.
 
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
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. All others are not maintained and may contain critical errors.
Google  


wwwlibrary
Best Practice Built-in Functions Built-in Packages New in 11gR1 New in 11gR2
TopicVersionLast ModifiedComment
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 01-Sep-2009 -
Anonymous Block 11gR2 10-Feb-2010
Anydata Data Type 11gR2 14-Dec-2009 -
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-Sep-2009 -
Arrays: Index by BINARY_INTEGER 11gR2 01-Sep-2009 -
Arrays: Index by VARCHAR2 11gR2 01-Sep-2009 -
AS OF Queries 11gR2 11-Sep-2009 -
AS REPLAY 11gR2 01-Nov-2009 -
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 01-Sep-2009 -
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 01-Sep-2009 -
Backup, Restore and Recovery 11gR1 03-Jun-2009 -
B*Tree Indexes 11gR2 01-Sep-2009 -
Bidirectional Cursor 11gR2 01-Sep-2009 -
Bind Variables 11gR2 01-Sep-2009 -
Bitmap Indexes 11gR2 01-Sep-2009 -
Bitmap Join Indexes 11gR2 01-Sep-2009 -
BLAST_CUR 11gR2 01-Sep-2009 -
Block Change Tracking 11gR2 01-Sep-2009 -
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 25-Feb-2010
Built-in Functions 11gR2 25-Dec-2009 -
Built-in Packages 11gR2 01-Sep-2009 -
Buffer Pool 11gR2 01-Sep-2009 -
Bulk Binding / Bulk Collection 11gR2 21-Sep-2009 -
CASE Function 11gR2 10-Nov-2009 -
Cast Function 11gR2 21-Feb-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 01-Sep-2009 -
Clusters 11gR2 21-Feb-2010
Codd's Rules - 07-Jul-2007 -
Collections 11gR2 13-Dec-2009 -
Collection Functions 11gR2 08-Nov-2009 -
Colored SQL 11gR2 01-Sep-2009 -
COLUMN_VALUE 11gR2 08-Sep-2009 -
Commit 11gR2 01-Sep-2009 -
Common Table Expressions 11gR2 01-Sep-2009 -
Compilation: Interpreted and Native 11gR2 01-Sep-2009 -
Compiler Directives 11gR2 09-Sep-2009 -
Compound Triggers 11gR2 01-Sep-2009 -
Composite Partitioning 11gR2 21-Feb-2010
Compressed Indexes 11gR2 05-Sep-2009 -
Compressed Tables 11gR2 05-Sep-2009 -
Compressed Tablespaces 11gR2 05-Sep-2009 -
Conditional Compilation 11gR2 01-Sep-2009 -
Conditions 11gR2 13-Nov-2009 -
Connect By 11gR2 10-Nov-2009 -
Constants 11gR2 10-Feb-2010
Constraints 11gR2 09-Sep-2009 -
Consumer Groups 11gR2 01-Sep-2009 -
Contexts 11gR2 01-Mar-2010
Continue Statement 11gR2 01-Sep-2009 -
Control Files 11gR2 01-Sep-2009 -
Control Structures 11gR2 26-Feb-2010
Conversion Functions 11gR2 03-Jan-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 10-Dec-2009 -
Data Files 11gR2 01-Feb-2010 -
Data Guard 11gR1 01-Feb-2010 -
Data Integrity 11gR2 02-Sep-2009 -
Data Mining Functions 11gR2 02-Sep-2009 -
Data Pump (API) 11gR2 28-Sep-2009 -
Data Pump (Executable) 11gR2 24-Sep-2009 -
Data Types & SubTypes 11gR2 14-Dec-2009 -
Database 11gR1 22-Feb-2009 -
Database Links 11gR2 02-Feb-2010 -
Date Functions 11gR2 09-Nov-2009 -
DBA Best Practice Guidelines 11gR2 02-Sep-2009 -
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 26-Feb-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 02-Sep-2009 -
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 01-Nov-2009 -
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 02-Sep-2009 -
DBMS_CHANGE_NOTIFICATION 11gR2 03-Feb-2010 -
DBMS_CLUSTDB 11gR2 02-Sep-2009 -
DBMS_COMPARISON 11gR2 01-Mar-2010
DBMS_COMPRESSION 11gR2 27-Sep-2009 -
DBMS_CONNECTION_POOL 11gR2 02-Sep-2009 -
DBMS_CQ_NOTIFICATIONS 11gR2 02-Sep-2009 -
DBMS_CRYPTO 11gR2 02-Sep-2009 -
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_DBLINK 11gR2 02-Sep-2009 -
DBMS_DBVERIFY 11gR2 02-Sep-2009 -
DBMS_DB_VERSION 11gR2 09-Sep-2009 -
DBMS_DDL 11gR2 24-Oct-2009 -
DBMS_DDL_INTERNAL 11gR2 02-Sep-2009 -
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 26-Sep-2009 -
DBMS_DST 11gR2 24-Oct-2009 -
DBMS_EDITIONS_UTILITIES 11gR2 02-Sep-2009 -
DBMS_EPG 11gR2 02-Sep-2009 -
DBMS_ERRLOG 11gR2 02-Sep-2009 -
DBMS_EXPFIL 11gR2 02-Sep-2009 -
DBMS_EXTENDED_TTS_CHECKS 11gR2 02-Sep-2009 -
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 17-Sep-2009 -
DBMS_FLASHBACK_ARCHIVE 11gR2 24-Oct-2009 -
DBMS_FREQUENT_ITEMSET 11gR2 02-Sep-2009 -
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 02-Sep-2009 -
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 31-Dec-2009 -
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 02-Sep-2009 -
DBMS_LOB 11gR2 18-Nov-2009 -
DBMS_LOBUTIL 11gR2 02-Sep-2009 -
DBMS_LOCK 11gR2 02-Sep-2009 -
DBMS_LOGMNR 11gR2 02-Sep-2009 -
DBMS_LOGMNR_D 11gR2 02-Sep-2009 -
DBMS_LOGSTDBY 11gR2 21-Feb-2010
DBMS_MANAGEMENT_PACKS 11gR2 02-Sep-2009 -
DBMS_METADATA 11gR2 01-Nov-2009 -
DBMS_METADATA_BUILD 11gR2 02-Sep-2009 -
DBMS_METADATA_DIFF 11gR2 26-Nov-2009 -
DBMS_METADATA_UTIL 11gR2 02-Sep-2009 -
DBMS_MONITOR 11gR2 02-Sep-2009 -
DBMS_MVIEW 11gR2 02-Sep-2009 -
DBMS_NETWORK_ACL_ADMIN 11gR2 02-Sep-2009 -
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 02-Sep-2009 -
DBMS_OUTLN 11gR2 02-Sep-2009 -
DBMS_OUTLN_EDIT 11gR2 02-Sep-2009 -
DBMS_OUTPUT 11gR2 02-Sep-2009 -
DBMS_PARALLEL_EXECUTE 11gR2 04-Sep-2009 -
DBMS_PARALLEL_EXECUTE_INTERNAL 11gR2 04-Sep-2009 -
DBMS_PCLXUTIL 11gR2 02-Sep-2009 -
DBMS_PIPE 11gR2 07-Feb-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 02-Sep-2009 -
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 02-Sep-2009 -
DBMS_REGISTRY_SERVER 11gR2 02-Sep-2009 -
DBMS_REGXDB 11gR2 02-Sep-2009 -
DBMS_REPAIR 11gR2 26-Feb-2010
DBMS_REPORT 11gR2 02-Sep-2009 -
DBMS_REPUTIL 11gR2 02-Sep-2009 -
DBMS_RESOURCE_MANAGER 11gR2 02-Sep-2009 -
DBMS_RESOURCE_MANAGER_PRIVS 11gR2 02-Sep-2009 -
DBMS_RESULT_CACHE 11gR2 21-Feb-2010
DBMS_RESUMABLE 11gR2 02-Sep-2009 -
DBMS_RLS 11gR2 02-Sep-2009 -
DBMS_ROWID 11gR2 02-Sep-2009 -
DBMS_SCHEDULER 11gR2 10-Dec-2009 -
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 03-Sep-2009 -
DBMS_SESSION 11gR2 03-Sep-2009 -
DBMS_SESSION_STATE 11gR2 26-Sep-2009 -
DBMS_SHARED_POOL 11gR2 03-Sep-2009 -
DBMS_SNAPSHOT 11gR2 03-Sep-2009 -
DBMS_SPACE 11gR2 03-Sep-2009 -
DBMS_SPACE_ADMIN 11gR2 21-Feb-2010
DBMS_SPM 11gR2 21-Nov-2009 -
DBMS_SQL 11gR2 03-Sep-2009 -
DBMS_SQLDIAG 11gR2 24-Oct-2009 -
DBMS_SQLHASH 11gR2 03-Sep-2009 -
DBMS_SQLJTYPE 11gR2 03-Sep-2009 -
DBMS_SQLPA 11gR2 26-Dec-2009 -
DBMS_SQLPLUS_SCRIPT 11gR2 03-Sep-2009 -
DBMS_SQLTUNE 11gR2 03-Sep-2009 -
DBMS_STANDARD 11gR2 21-Feb-2010
DBMS_STAT_FUNCS 11gR2 03-Sep-2009 -
DBMS_STATS 11gR2 03-Jan-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_SUPPORT 11gR2 03-Sep-2009 -
DBMS_SYSTEM 11gR2 03-Feb-2010 -
DBMS_TDB 11gR2 03-Sep-2009 -
DBMS_TRACE 11gR2 03-Sep-2009 -
DBMS_TRANSACTION 11gR2 03-Sep-2009 -
DBMS_TRANSFORM 11gR2 03-Sep-2009 -
DBMS_TTS 11gR2 26-Sep-2009 -
DBMS_TYPES 11gR2 03-Sep-2009 -
DBMS_UNDO_ADV 11gR2 03-Sep-2009 -
DBMS_UTILITY 11gR2 02-Mar-2010
DBMS_WARNING 11gR2 03-Sep-2009 -
DBMS_WARNING_INTERNAL 11gR2 04-Sep-2009 -
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 04-Sep-2009 -
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 10-Nov-2009 -
Deferrable Constraints 11gR2 09-Sep-2009 -
Delete Statement 11gR2 10-Sep-2009 -
Descending Indexes 11gR2 01-Sep-2009 -
DICOM 11gR1 10-Oct-2009 -
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 08-Nov-2009 -
Dynamic Performance Views 11gR2 01-Jan-2010 -
E-Business Suite 11.5.10 29-Sep-2007 -
Editioning Demo 1: Editions 11gR2 23-Feb-2010
Editioning Demo 2: Editioning Views 11gR2 09-Mar-2010
Editioning Demo 3: Crossedition Triggers 11gR2 02-Mar-2010
Editioning Demo 4: DBMS_SQL.PARSE 11gR2 Coming Soon -
Editioning Views 11gR2 24-Feb-2010
Editions 11gR2 16-Feb-2010
Encrypted Tablespaces 11gR2 28-Sep-2009 -
Environment Variables 11gR2 11-Sep-2009 -
Errors 11gR2 11-Sep-2009 -
Events 11gR2 06-Oct-2009 -
Exadata 11gR2 24-Dec-2009 -
Exception Handling 11gR2 21-Feb-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 -
External Tables 11gR2 06-Feb-2010 -
Files Of Interest 11gR2 11-Sep-2009 -
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 11-Sep-2009 -
Flashback Database 11gR2 11-Sep-2009 -
Flashback Drop 11gR2 11-Sep-2009 -
Flashback Query 11gR2 11-Sep-2009 -
Flashback Table 11gR2 11-Sep-2009 -
Flashback Transaction 11gR2 11-Sep-2009 -
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 11gR2 21-Sep-2009 -
Foreign Key Constraint 11gR2 09-Sep-2009 -
FORMs Developer 10.1.2.0.2 16-Aug-2009 -
Function Based Indexes 11gR2 01-Sep-2009 -
Functions: Deterministic 11gR2 11-Sep-2009 -
Functions: Miscellaneous 11gR2 09-Nov-2009 -
Functions: User Defined 11gR2 11-Sep-2009 -
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 16-Jan-2010 -
Global Partitioned Indexes 11gR2 21-Feb-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 11-Sep-2009 -
GROUP ID 11gR2 10-Nov-2009 -
GROUPING SETS 11gR2 10-Nov-2009 -
Guaranteed Restore Point 11gR2 11-Sep-2009 -
GV$ Views 11gR2 28-Sep-2009 -
Hash Partitioning 11gR2 21-Feb-2010
HAVING Clauses 11gR2 11-Sep-2009 -
Heap Tables 11gR2 21-Feb-2010
Hints 11gR2 06-Feb-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 27-Jan-2010 -
Indexes 11gR2 28-Sep-2009 -
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 28-Jan-2010 -
Instead-Of Triggers 11gR2 15-Sep-2009 -
Instring Function 11gR2 10-Nov-2009 -
Intermedia Audio 11gR1 25-Aug-2008 -
Intermedia Video 11gR1 25-Aug-2008 -
Interval 11gR2 09-Nov-2009 -
Interval Partitioning 11gR2 21-Feb-2010
Interview Questions 11gR2 01-Jan-2010 -
Invisible Indexes 11gR2 01-Sep-2009 -
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 15-Sep-2009 -
Keep Pool 11gR2 15-Sep-2009 -
Killing Sessions 11gR2 15-Feb-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 25-Dec-2009 -
List Partitioning 11gR2 21-Feb-2010
Listener 11gR2 15-Sep-2009 -
LOB Compression 11gR2 15-Sep-2009 -
LOBs 11gR2 15-Sep-2009 -
Local Partitioned Indexes 11gR2 21-Feb-2010
Locks 11gR2 22-Feb-2010
Log Files 11gR2 15-Sep-2009 -
Log Miner 11gR2 02-Sep-2009 -
LONG To CLOB 11gR2 15-Sep-2009 -
Loops 11gR2 26-Feb-2010
LT Built-in Package 11gR2 04-Sep-2009 -
Materialized Views 11gR2 24-Dec-2009 -
Materialized View Logs 11gR2 24-Dec-2009 -
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 -
Mutating Trigger 11gR1 28-Feb-2010
Multimedia Audio 11gR1 25-Aug-2008 -
Multimedia Video 11gR1 25-Aug-2008 -
Multiset 11gR2 01-Sep-2009 -
Multiversion Concurrency Control (MVCC) 11gR2 15-Sep-2009 -
Native Compilation 11gR2 15-Sep-2009 -
Native Dynamic SQL (NDS) 11gR2 06-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 01-Sep-2009 -
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 21-Jan-2010 -
OPEN FOR 11gR2 16-Sep-2009 -
Opatch 11gR2 10-Sep-2009 -
Operators: Built-in 11gR2 13-Nov-2009 -
Operators: User Defined 11gR2 16-Sep-2009 -
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 16-Sep-2009 -
Packages: User Defined 11gR2 02-Sep-2009 -
Parent Correlation Name 11gR2 15-Sep-2009 -
Partitioning (tables and indexes) 11gR2 21-Feb-2010
Partitioning by Reference 11gR2 21-Feb-2010
Partition by System 11gR2 21-Feb-2010
Partitioning Elimination Demo 11gR2 21-Feb-2010
Partitioning Pruning Demo 11gR2 21-Feb-2010
Password File 11gR2 10-Sep-2009 -
Pipelined Table Functions 11gR2 26-Dec-2009 -
Pivot 11gR2 01-Sep-2009 -
PLSHPROF 11gR2 06-Oct-2009 -
PLSQL_CCFLAGS 11gR2 16-Sep-2009 -
PL/Scope 11gR1 02-Feb-2008 -
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 23-Feb-2010
Product User Profiles 11gR2 16-Sep-2009 -
Profiles 11gR2 16-Sep-2009 -
Protocol.ora 11gR2 27-Sep-2008 -
PRVT_COMPRESSION 11gR2 09-Mar-2010
Pseudo Columns 11gR2 20-Jan-2010 -
Public Synonyms 11gR2 17-Sep-2009 -
Purge Recyclebin 11gR2 17-Sep-2009 -
Purge Table 11gR2 17-Sep-2009 -
Quote Delimiters 11gR2 11-Sep-2009 -
RAC 11gR1 06-Dec-2009 -
RAID 11gR2 17-Sep-2009 -
RAISE 11gR2 11-Sep-2009 -
RAISE_APPLICATION_ERROR 11gR2 11-Sep-2009 -
Range Partitioning 11gR2 05-Jan-2010 -
Rank 11gR2 17-Sep-2009 -
RDA 11gR2 17-Sep-2009 -
Read Only Tables 11gR2 17-Sep-2009 -
Real Application Clusters 11gR1 06-Dec-2009 -
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 05-Jan-2010 -
Regular Expressions 11gR2 09-Nov-2009 -
Remote Diagnostic Agent 11gR2 17-Sep-2009 -
Replace Built-in Function 11gR2 17-Sep-2009 -
Restore Point 11gR2 11-Sep-2009 -
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 01-Sep-2009 -
Rewrite Equivalence 11gR2 02-Sep-2009 -
RMAN 11gR2 01-Jan-2010 -
RMAN Demo 11gR2 27-Feb-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 18-Sep-2009 -
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 -
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 05-Jan-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 24-Nov-2009 -
Stored Outlines 11gR2 06-Mar-2010
Stored Procedures 11gR2 23-Feb-2010
Storage - 17-Sep-2009 -
Streams Demo 1 10gR2 07-Jun-2007 -
Streams Demo 2 10gR2 07-Jun-2007 -
Streams Demo 3 10gR2 07-Jun-2007 -
String Functions 11gR2 08-Nov-2009 -
Subqueries 11gR2 11-Sep-2009 -
Subquery Factoring 11gR2 01-Sep-2009 -
Substring Function 11gR2 10-Nov-2009 -
Subtypes 11gR2 21-Nov-2009 -
Synonyms 11gR2 17-Sep-2009 -
SYS_CONTEXT Built-in Function 11gR2 01-Mar-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 22-Oct-2009 -
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 21-Feb-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 06-Oct-2009 -
Total Recall 11gR2 11-Sep-2009 -
Trace File Identifier 11gR2 06-Oct-2009 -
Tracing 11gR2 06-Oct-2009 -
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 30-Dec-2009 -
Transportable Tablespaces 11gR2 20-Sep-2009 -
Truncate (Tables & Partitions) 11gR2 20-Sep-2009 -
Tuning 11gR2 28-Dec-2009 -
Types 11gR2 20-Sep-2009 -
Undo Compression 11gR2 19-Dec-2009 -
Undo Tablespace 11gR2 20-Sep-2009 -
Undocumented Oracle 11gR2 08-Jan-2010 -
Uninstall Oracle 11gR2 20-Sep-2009 -
UNIX / vi - 06-Jan-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-Nov-2009 -
USER_LOCK 11gR2 04-Sep-2009 -
Utilities 11gR2 10-Sep-2009 -
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_PG 11gR2 08-Nov-2009 -
UTL_RAW 11gR2 03-Jan-2010 -
UTL_RECOMP 11gR2 04-Sep-2009 -
UTL_REF 11gR2 04-Sep-2009 -
UTL_SMTP 11gR2 25-Oct-2009 -
UTL_SPADV 11gR2 04-Sep-2009 -
UTL_SYS_COMPRESS 11gR2 04-Sep-2009 -
UTL_TCP 11gR2 04-Sep-2009 -
UTL_URL 11gR2 04-Sep-2009 -
UTL_XML 11gR2 31-Oct-2009 -
Variables 11gR2 10-Feb-2010
VARRAYS 11gR2 18-Sep-2009 -
VERSIONS BETWEEN 11gR2 08-Sep-2009 -
Views 11gR2 24-Feb-2010
Virtual Columns 11gR2 12-Sep-2009 -
Virtual Column Partitioning 11gR2 05-Jan-2010 -
Virtual Indexes 11gR2 01-Sep-2009 -
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-Sep-2009 -
Where Clause 11gR2 20-Sep-2009 -
Wildcards 11gR2 20-Sep-2009 -
WITH Clause 11gR2 01-Nov-2009 -
WM_CONCAT 11gR2 20-Sep-2009 -
WM_CONTAINS 11gR2 20-Sep-2009 -
WM_EQUALS 11gR2 20-Sep-2009 -
WM_GREATERTHAN 11gR2 20-Sep-2009 -
WM_INTERSECTION 11gR2 20-Sep-2009 -
WM_LDIFF 11gR2 20-Sep-2009 -
WM_LESSTHAN 11gR2 20-Sep-2009 -
WM_MEETS 11gR2 20-Sep-2009 -
WM_OVERLAPS 11gR2 20-Sep-2009 -
WM_RDIFF 11gR2 20-Sep-2009 -
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 03-Feb-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 is site maintained by Dan Morgan. Last Updated: Contact Us Legal Notices & Terms of Use  Privacy Statement