Introduction Real Application Clusters (RAC) allows multiple computers to run Oracle software simultaneously while accessing a single database, therefore providing a clustered database. In the previous non-RAC oracle database, a single instance accesses a single database. And we know that clustering is the task of assigning a set of objects into groups. In an Oracle [...]
About Contributing Author
Author Archive | Contributing Author
Understanding Oracle 11g Constraints
Introduction to Constraints Oracle constraints are defined as the rules to preserve the data integrity in the application. These rules are imposed on a column of a database table, so as to define the basic behavioral layer of a column of the table and check the sanctity of the data flowing into it. The data [...]
Introduction to Oracle 11g Cursors
Cursors are one of the most common and fundamental terms in the database terminology. It is one of the core database programming concepts, which forms a basic unit of execution of SQL statement. A cursor is a pointer, which points towards a pre allocated memory location in the SGA. For transparent understanding, it is a [...]
Using Triggers and Compound Triggers in Oracle 11g
In database terminology, triggers are the objects which demonstrate the logic of schedule and automation. Triggers are automatically invoked at a defined event and timing without any explicit calls. The logic embedded within the trigger and invocation must be well directed and synchronized to maintain database purity. Oracle 11g made remarkable enhancements in Database Triggers. [...]
Oracle 11g R2 SQL Enhancements
With each and every release of RDBMS, Oracle has achieved great commercial success and attained zeniths of exploration. The year 2007 saw the release of Oracle RDBMS version 11g (second grid computed version after Oracle 10g). First release of Oracle 11g facilitated the developers with multiple enhancements and language features. The introduction of advanced core [...]
Using EXISTS in Oracle SQL Queries
By definition, an operator works with the data items (known as operands) and returns a result. Oracle provides multiple operators under various categories which can be used in queries to filter the result set. In SQL, EXISTS is an operator which can be used in WHERE clause to validate an “IT EXISTS” condition. In the [...]
Using Oracle 11g Sequences
Oracle Sequences have efficiently fulfilled the requirement of generation of unique numbers in a table. They can be casted as Primary Key of a table. In the current article, we shall note the applications of a Sequence, its features and behavior in various scenarios. Introduction Oracle introduced Sequences in its sixth release (Oracle 6) to [...]
Oracle 11g New Features for Developers
With each and every release, Oracle has tried to provide best database services to the users across the world. Over the period of time and releases, it has become more intelligent, efficient, strong, reliable, flexible and secure. Introduction Oracle 11g Release 2 is the latest release of Oracle in 11g series. Unlike the last release [...]
Search
- Oracle 11g New Features for Developers February 2, 2011
- What is a Schema in SQL Server 2005? February 21, 2009
- Introduction to Oracle 11g Cursors June 23, 2011
-
Using Oracle 11g Sequences
March 31, 2011
-
Master Advanced PL/SQL concepts with “Oracle Advanced PL/SQL Developer Professional Guide”
April 3, 2012
- Using SQL Sprocket to generate TSQL Stored Procedures June 30, 2012
- Concepts for Developing Oracle 11g RAC enabled Applications June 25, 2012
- Generate dynamic columns using a single variable for PIVOT June 25, 2012
-
Master Advanced PL/SQL concepts with “Oracle Advanced PL/SQL Developer Professional Guide”
April 3, 2012
- What is a Database? January 1, 2012
-
Hitendra Yadav: Really good artical....
-
kolimisteenused: When some one searches for his required thing, so ...
-
homesecuritydeals.com: Hey there! Someone in my Facebook group shared thi...
-
Umesh: Good list of commands. I have also listed 20 Most ...
-
Saurabh K. Gupta: Thanks guyz for liking the article. It has been mo...
