Oracle Articles Examples, Tutorials and Articles
Published by
1. Introduction
Virtual Columns are one of the most interesting features of Oracle 11g. It allows users to create columns whose data is not supplied by the user, but it is derived by Oracle server implicitly from other columns. Most importantly, their disk space consumption is NULL because ...
Virtual Columns are one of the most interesting features of Oracle 11g. It allows users to create columns whose data is not supplied by the user, but it is derived by Oracle server implicitly from other columns. Most importantly, their disk space consumption is NULL because ...
Published by
1. Overview
Triggers are named PL/SQL subprograms which are invoked automatically by Oracle at predefined timing and event. Timing and event are set in the trigger definition. Similar to other subprograms, triggers are physically stored in database.
Triggers prove to be ...
Triggers are named PL/SQL subprograms which are invoked automatically by Oracle at predefined timing and event. Timing and event are set in the trigger definition. Similar to other subprograms, triggers are physically stored in database.
Triggers prove to be ...
Published by
1. Introduction
Invisible Indexes are another feature which was introduced in Oracle 11g. It is nothing but a normal index on tables whose usability by the optimizer is set by a parameter. Oracle optimizer would ignore an invisible index on the table if the initialization parameter OPTIMIZER_USE_INVISIBLE_INDEXES ...
Invisible Indexes are another feature which was introduced in Oracle 11g. It is nothing but a normal index on tables whose usability by the optimizer is set by a parameter. Oracle optimizer would ignore an invisible index on the table if the initialization parameter OPTIMIZER_USE_INVISIBLE_INDEXES ...
Published by
1. Introduction
A Procedure is a named PL/SQL subprogram that can be optionally parameterized and is used to implement business logic. It is permanently stored in the database as schema object and can be invoked any number of times on specified set of data.
Advantages ...
A Procedure is a named PL/SQL subprogram that can be optionally parameterized and is used to implement business logic. It is permanently stored in the database as schema object and can be invoked any number of times on specified set of data.
Advantages ...
Published by
1. Introduction
Exception is an uneven break in the program flow due to logical issues in the PL/SQL block. It is raised by Oracle server and the execution process is aborted as soon as it is encountered. It can be trapped and handled in the EXCEPTION section of a PL/SQL block. Note that ...
Exception is an uneven break in the program flow due to logical issues in the PL/SQL block. It is raised by Oracle server and the execution process is aborted as soon as it is encountered. It can be trapped and handled in the EXCEPTION section of a PL/SQL block. Note that ...
Published by
REF CURSOR Overview
A cursor variable is a cursor that actually contains a pointer to a query result set. The result set is determined by the execution of the OPEN FOR statement using the cursor variable.
EnterpriseDB currently supports both strongly and weakly typed REF ...
A cursor variable is a cursor that actually contains a pointer to a query result set. The result set is determined by the execution of the OPEN FOR statement using the cursor variable.
EnterpriseDB currently supports both strongly and weakly typed REF ...
1
Comment
Published by
1. Overview
Oracle 11g came up with multiple enhancements for Developers. One of the significant among them was the introduction of Compound Triggers. The article explains the use of Compund Trigges and related notes.
2. Introduction
Compound triggers are one of ...
Oracle 11g came up with multiple enhancements for Developers. One of the significant among them was the introduction of Compound Triggers. The article explains the use of Compund Trigges and related notes.
2. Introduction
Compound triggers are one of ...
Published by
1. Overview of Stored Functions
A Function is a named PL/SQL subprogram, which when called from SQL or PL/SQL statement, mandatorily returns one and only one value. Functions are used to implement computation based logic. They are stored as schema objects in database. They promote reusability ...
A Function is a named PL/SQL subprogram, which when called from SQL or PL/SQL statement, mandatorily returns one and only one value. Functions are used to implement computation based logic. They are stored as schema objects in database. They promote reusability ...
Published by
1. Overview
Representing the data in various orientations is achieved by Views. We create views on top of database tables to represent the data in a logical and meaningful way.
2. Introduction
Views are the database objects which represent data in desired ...
Representing the data in various orientations is achieved by Views. We create views on top of database tables to represent the data in a logical and meaningful way.
2. Introduction
Views are the database objects which represent data in desired ...
Published by
1. Overview
Database performance is one of the primary objectives of database administration. Code performance is degraded when the processing engine makes more I/O on the disk or multiple context switching. One important technique to reduce the performance overhead is Indexing. We shall ...
Database performance is one of the primary objectives of database administration. Code performance is degraded when the processing engine makes more I/O on the disk or multiple context switching. One important technique to reduce the performance overhead is Indexing. We shall ...
