Category: Oracle 11g Tutorials

Overview

Oracle 11g was introduced in the year 2009. Since its release, Oracle 11g has become the topic of discussion amongst the database developers. Oracle 11g has arrived with the performance oriented features, language enhancements and logical programming recommendations.

Training Objective

This section includes Oracle 11g tutorials which aim to educate the readers about Oracle database concepts. The objective of this tutorial series is to discuss new features in SQL, PL/SQL, Native Compilation, Result Cache and many other aspects incorporated in Oracle 11g release. This series will also demonstrate the implementation procedures of various new features and study its impacts.

Target Audience

Oracle 11g tutorials provides concrete self-learning platform for beginners and will strengthen the fundamentals for intermediate database professionals.

Related Trainings

PL/SQL Tutorials
Oracle 9i Training
Oracle 10g Training
Oracle Apps 11i

Oracle XML Storage

June 19, 2012March 20, 2014 Saurabh Gupta

With the growing dimensions of data requirements, the nature of Information or ‘Data’ has taken multiple folds. The ‘Organizational data’ today cannot be expected in conventional and structural form, but it mostly exists in unstructured format. The database platform also must grow parallel to facilitate the able storage and sustain the growing developments. Read More

Oracle Analytic Enhancements

June 19, 2012March 5, 2014 Saurabh Gupta

Since the release of Oracle 8.1.6, analytic functions have emerged as a major extended strength of SQL language. Analytic functions address the problems like moving averages, cumulative sums, ranking, percentile and many other problems which are crucial for OLAP applications. Read More

Oracle Partitioning Overview

January 17, 2012March 22, 2014 Saurabh Gupta

Partitioning is the method which physically segregates large tables or indexes can be realized into smaller logical groups.Each logical piece is a realizable table or index, and referred as a ‘partition’. Read More

PL/Scope and PL/SQL Hierarchical Profiler

November 6, 2011March 25, 2014 Saurabh Gupta

Since the time Oracle 11g has been released way back in the year 2003, it has waved a new exploring instinct among the database users. Till now, I observe the professionals engaged trying their hands out with Oracle 11g new features. Read More

Oracle VPD implementation

October 24, 2011March 22, 2014 Saurabh Gupta

Oracle has provided several solutions to ensure and secure the database. An efficient security policy not only prevents the database against the database corruption or hacking threats but also minimizes the risk of unprivileged user access. Read More

Oracle 11g SecureFiles

September 4, 2011March 22, 2014 Saurabh Gupta

Relational content looks fine and flexible to follow even crude strategies of storage but unstructured data like documents of varied sort, audios, videos, and many more are add up the challenges for designers and architects. Read More

Manage Oracle dependencies

August 16, 2011March 22, 2014 Saurabh Gupta

Oracle schema is the home for all the database objects. It shelters the entire set of objects which participate in the data storage layer (tables, views) and data access layer (package, procedures, functions, triggers). Read More

UTL_FILE

August 10, 2011March 22, 2014 Saurabh Gupta

UTL_FILE is an oracle supplied built in package, which can be used for text file operations located within a file system. The file system can exist either on the server side or on the client machine. Read More

Oracle Pragma

July 6, 2011March 22, 2014 Saurabh Gupta

In a programming language, compiler plays a crucial role in execution of a program. Compiler is a language component which converts a source code, written using one of the interactive programming languages, into machine code, which the server can interpret and act upon. Read More

Conditional compilation in Oracle PL/SQL

June 28, 2011March 22, 2014 Saurabh Gupta

Oracle 10g introduced conditional compilation feature in its second release. The conditional compilation feature enables a developer to impose conditions on the compiler. This implies that out of the complete source code of a program unit, only the part of code, which qualifies these conditions, would be compiled. Read More

Oracle 11g Subprogram Overloading

June 17, 2011March 22, 2014 Saurabh Gupta

Polymorphism is an Object Oriented Programming language feature which allows the objects to accept same input and behave differently. It can be implemented in three ways i.e. overriding, hiding, and overloading. Read More

Oracle 11g Read Only Tables

June 16, 2011March 22, 2014 Saurabh Gupta

A Read-Only table is a normal data storage table, which restricts any transactional action on it. In the tutorial, we shall study the behavior of READ-ONLY tables under different scenarios. Read More

Oracle 11g Exception Handling

June 9, 2011March 22, 2014 Saurabh Gupta

Exception can be defined as the state of an entity, which is different from its conventional and normal behavior. In context to programming language, exception refers to the abnormal situation in the normal flow of the program. Read More

Oracle Functions and Procedures

June 7, 2011March 22, 2014 Saurabh Gupta

Encapsulation and modularity are the few of the generic and recommended language features, which enhance efficiency and scalability of the language in the application. Oracle database language implements these features through stored subprograms. Read More

Oracle 11g Collections

June 2, 2011March 22, 2014 Saurabh Gupta

Composite data types are hybrid types which are capable of holding components of varying data type. Oracle implements composite data type in two forms, either as PL/SQL records or PL/SQL collections. Read More

Oracle 11g Virtual Columns

May 30, 2011March 22, 2014 Saurabh Gupta

Oracle 11g had brought multiple language enhancement features. These features have not only added the language utility, but also widened the programming scope of database developers. Read More

Oracle 11g Invisible Index

May 27, 2011March 22, 2014 Saurabh Gupta

Oracle 11g release has introduced a new property of an Index i.e. Visibility. Before the world saw 11g release, an index was always created and existed in visible mode. But now, as per the fresh feature in Oracle 11g, an index may exist in Invisible Mode too. Read More

Compound Triggers in Oracle 11g

May 9, 2011March 22, 2014 Saurabh Gupta

Oracle 11g offers considerable improvements in database triggers. These additions have not only enhanced the language usability but also promise a better performance in a real application environment. Read More

Oracle 11g Result Cache

April 28, 2011March 22, 2014 Saurabh Gupta

Result Caching is a new feature introduced in Oracle 11g. Since its induction in the 11g release, caching of result sets has emerged out as one of the most efficient performance tip in modern database applications. Read More