Introduction to oracle, PL-SQL Programming

Introduction

Oracle 9i- it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet applications (both business model and their operation).It is known for its strength in offering performance, scaling, and availability in hosted services exhibited in any software. A real application clusters is a computer-cluster database. In Oracle 9i, Real Application Clusters substituted the Oracle Parallel Server.

Oracle 10g- This database became the first RDBMS release from Oracle Corporation after Oracle 9i that advanced Grid computing technology. Besides these multiple features and advancements, Oracle 10g released resolved the bugs reported from the previous edition of databases like oracle 9i. Major language features included continuing expression functionality support, flashback operations support; recycle bin, and performance improvements. With the rising fame of 10g versions first release, when it became successful then oracle released second edition of 10g in 2005.

Oracle 11g- This is latest released databases of oracle, it was released in 2009. Since its inception, Oracle 11g has become the topic of discussions amongst the database developers and engineers, corporate that are actually utilizing and advancing their operation. Oracle 11g has well equipped with the performance oriented features, language enhancements and logical programming recommendations.

 

Posted Date: 3/14/2013 2:15:27 AM | Location : United States







Related Discussions:- Introduction to oracle, Assignment Help, Ask Question on Introduction to oracle, Get Answer, Expert's Help, Introduction to oracle Discussions

Write discussion on Introduction to oracle
Your posts are moderated
Related Questions
THEO R Y OF CATASTROPHISM OR CATALYSM (CUVIER 1769-1832) - The world has passed thorugh several stages and at the end of each stage there was a catastrophe killing all the

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

Parameter and Keyword Description: cursor_variable_name: This identifies a cursor variable or the parameter formerly declared within the present scope. host_cursor_va

to write a heap sort program usin pl-sql

What Are Cursor Variables  ? The Cursor variables are like C or Pascal pointers that hold the memory location (address) of some item rather of the item itself. Therefore, decl

Using Operator REF: You can retrieve refs by using the operator REF that, like VALUE, takes as its argument a correlation variable. In the illustration below, you retrieve one

Using raise_application_error The Package DBMS_STANDARD that is supplied with Oracle gives language facilities that help your application to interact with Oracle. For illustra

Using NOT NULL Besides assigning an initial value, the declarations can impose the NOT NULL constraint, as the example below shows: acct_id INTEGER(4) NOT NULL := 9999; You ca

Object Type: The object type is a user-defined composite datatype which encapsulates a data structure along with the functions and procedures required to manipulate the data

Consider the schema for FreeChecking Bank, that we designed given below. Translate the given ER schema into SQL CREATE TABLE statements (indicating primary key, unique and foreign