Majority of differences among 9i-10g-11g, PL-SQL Programming

Majority of Differences among 9i, 10G, 11G:-

These are some combine feature which has differences among others.

  1. Automatic Workload Repository (AWR)
  2. Drop database' statement
  3. Automatic Database Diagnostic Monitor (ADDM)
  4. UNDROP a table from a recycle bin rename Table-space
  5. Transport Table-space across machine types (E.g. Windows to Unix)
  6. Flashback operation on transaction, table or database level


Posted Date: 3/14/2013 2:25:21 AM | Location : United States

Related Discussions:- Majority of differences among 9i-10g-11g, Assignment Help, Ask Question on Majority of differences among 9i-10g-11g, Get Answer, Expert's Help, Majority of differences among 9i-10g-11g Discussions

Write discussion on Majority of differences among 9i-10g-11g
Your posts are moderated
Related Questions
PL SQL Code Review HEADER ELEMENTS File Name Clear, meaningful and descriptive about main objective of the file. Multiple words are joined using underscores which adh

Using EXCEPTION_INIT To handle unnamed internal exceptions, you should use the OTHERS handler or the pragma EXCEPTION_INIT. The pragma is a compiler directive that can be th

FORALL Statement The FORALL statements instruct the PL/SQL engine to bulk-bind the input collections before sending them to the SQL engine. Though the FORALL statement consists

Iteration Schemes The bounds of a loop range can be variables, literals, variables, or expressions but must compute to integers. Below are some of the examples. As you can see t

Primary Key - SQL A PRIMARY KEY specification carries an implicit NOT NULL constraint on each column of the specified key. When more than one key constraint is required, the k

Built-In Functions The PL/SQL provides a lot of powerful functions to help you to manipulate the data. These built-in functions fall into the categories as shown below: error r

Special cases of projection This section describes the identity projection, r {ALL BUT}, and the projection on no attributes, r { }, which yields TABLE_DUM when r is empty, ot

Data Abstraction The Data abstraction extracts the important properties of data while ignoring the not necessary details. Once you design a data structure, you can fail to reme

Control Structures The Control structures are the most important PL/SQL extension to the SQL. Not only does PL/SQL let you manipulate Oracle data, it lets you process the data

Recursion The Recursion is a powerful method for simplify the design of the algorithms. Principally, the recursion means the self-reference. In the recursive mathematical serie