- Enhancements to regular expression built-in SQL functions
- SIMPLE_INTEGER, SIMPLE_FLOAT, and SIMPLE_DOUBLE datatypes
- CONTINUE statement
- Sequences in PL/SQL expressions
- Dynamic SQL enhancements
- More control over triggers
- Compound triggers
- Database resident connection pool
- Automatic subprogram inlining
- PL/Scope
- PL/SQL hierarchical profiler
- PL/SQL native compiler generates native code directly
Tips and good resources for all.. Oracle, Big data, Hadoop, Unix, Linux
Tuesday, October 9, 2012
New PL/SQL Features and Enhancements in Oracle 11g
Saturday, September 3, 2011
What are the major difference between Oracle9i and Oracle10g?
Oracle 9i has the following new features:
- Direct XML database support.
- Oracle Data Guard and enhancements.
- New data sharing and replication features.
- Compresses keys in tables when loading data.
- Security Improvements.
- Manage system table spaces locally.
- Automated DBA.
Oracle 10g has following new features:
- New drop database and alter database begin backup syntax.
- Oracle 10g Data Guard Broker and RAC to support Redo Log Transport.
- SQL apply feature and regular expression support.
- Supports HTML database.
- Recycle bin for storing objects and new purge command.
- SYSAUX table space and rename table space command.
- Automated Storage Management (ASM).
- Automatic Workload Repository (AWR).
- Automatic Database Diagnostic Monitor (ADDM)
- PLS_INTEGER, a new data type was added which enhances performance. ANYDATA data type was introduced to hold a data of variant feature.
Subscribe to:
Posts (Atom)