Contents
What is the difference between Oracle 10g and 11g?
Compared with Oracle 10g, the later version of Oracle 11g offers more simplified, automated, and advanced memory management tools and features. Oracle 11g offers invisible indexes, table partitioning, virtual columns, and the capability of redefining tables with materialized view logs even while the users are online.
What is new features in Oracle 11g?
Oracle 11g introduced new features and enhancements in below areas: Performance Improvements. Enhancements to improvise the usability and compatibility of PL/SQL as a language. Include earlier workaround implementations as language features.
Is PL SQL and Oracle are same?
PL/SQL is Oracle’s procedural language extension to SQL. Oracle also allows you to create and store functions, which are similar to procedures, and packages, which are groups of procedures and functions.
What does G stand for in Oracle 10g?
Grid Computing
Oracle 10g, 11g 10g and 11g stands for GRID. Starting in 2003 with version 10g and 11g, G signifies “Grid Computing” with the release of Oracle10g in 2003. Oracle 10g was introduced with emphasis on the “g” for grid computing, which enables clusters of low-cost, industry standard servers to be treated as a single unit.
What’s new in PL SQL?
PL/SQL New Features and Enhancements in Oracle Database 11g Release 1
- Enhancements to Regular Expression Built-in SQL Functions.
- SIMPLE_INTEGER Datatype.
- Sequences in PL/SQL Expressions.
- Dynamic SQL Enhancements.
- Generalized Invocation.
- Named and Mixed Notation in PL/SQL Subprogram Invocations.
What’s the difference between Oracle Database 11.2.0.4 and 12.1.0?
Therefore you will have to do exactly the same amount of testing, regardless of going to Oracle Database 11.2.0.4 vs Oracle Database 12.1.0.2 – it is ZERO difference in the tests, the time, the effort, the manpower … . You don’t believe me? Then please check MOS Note:1962125.1 (Oracle Database – Overview of Database Patch Delivery Methods).
What’s the difference between 11.2.0.1 and 11.3.0?
But the following discussion on Twitter with comments from all sides made me think about why people would honestly declare going for instance from 11.2.0.1 to 11.2.0.3 as a minor upgrade whereas going to 12.1.0.2 is seen as a major upgrade? Let me summarize why I completely disagree – and actually Dom Giles nailed it:
What are new features in Oracle 11g Release 2?
This chapter contains descriptions of all of the features that are new to Oracle 11 g Database, Release 2. This chapter contains the following sections: The following sections describe the new application development features for Oracle Database 11 g Release 2 (11.2). The following sections describe Oracle Application Express features.
Can you upgrade an Oracle database to 12.1?
After upgrading to 12.1, that database would have to be 12.1.0.1 or higher to have the possibility of being directly upgraded to a higher version and release levels. Alternatively, the 11.2.0.2 database could be upgraded to 11.2.0.3 or higher and directly upgraded to any higher version 12.1 up to 19c.