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
Parameter and Keyword Description:   table_reference: This identifies a table or view which should be available when you execute the INSERT statement, and for that you sho

Explicitly specifying the join condition - SQL SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON ON ( IS_CALLED.StudentId = IS_ENROLLED_ON.StudentId ) Now, the key word JO

Benefit of the dynamic SQL: This part shows you how to take full benefit of the dynamic SQL and how to keep away from some of the common pitfalls. Passing the Names of Sc

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

THEO R Y OF ETERNITY OF LIFE (PRAYER - 1880) - The theory of eternity of life, also called the steady-state theory , states that life has ever been in existence as at presen

BETWEEN Operator The operator BETWEEN, tests whether the value lies in a specified series. That means "greater than or equivalent to low value and less than or equivalent to hig

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

Effect of Anonymous Columns Now, recall that a VALUES expression denotes a table with undefined column names. If an initial value is to be specified when a base table is creat

%ROWTYPE: This attribute gives a record type which represents a row in the database table or a row fetched from a formerly declared cursor. The Fields in the record and corresp

SSRS Report Writing Project Description: This report is part of a larger project to make a SQL Server Reporting Service (SSRS) based reporting solution. There can be more rep