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
UPDATE Command- SQL Loosely speaking, UPDATE changes some of the column values of some existing rows of its target table. Thus, although some rows disappear from the target an

Using Invoker Rights: By default, the stored procedure executes with the privileges of its definer, not its invoker. These procedures are bound to the schema in which they inh

Transactions in SQL BEGIN TRANSACTION, COMMIT, and ROLLBACK, SQL has the same syntax except for START in place of BEGIN. However, START TRANSACTION is used only for outermost

COSMOZOI C THEORY - Richter (1865) proposed the cosmozoic theory that says that life came by spores (cosmozoa) or other particles from other planets on the earth.

Advantages of Packages The benefits of the Packages are as shown below: Modularity The Packages encapsulate logically associated items, types, and subprograms in the

Example of NOT EXISTS in SQL Example: Use of NOT EXISTS CREATE ASSERTION Must_be_enrolled_to_take_exam_alternative1 CHECK ( NOT EXISTS (SELECT StudentId, CourseId

BETWEEN and NOT BETWEEN Operator in SQL Example: Restricting exam marks to between 0 and 100 CREATE ASSERTION Marks_between_0_and_100 CHECK (NOT EXISTS (SELECT * FROM

Row Counterparts of Table Operators SQL does not have counterparts tuple rename, tuple projection, tuple extension, tuple join and tuple compose. To obtain the same effects as

Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.

Packaging Cursors   You can split a cursor specification from its body for placement in a package. In that way, you can change the cursor body without changing the cursor spec