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
Packages The package is a schema object which groups logically associated to the PL/SQL items, types, and subprograms. The Packages have 2 sections: the specification & the bod

Opening a Cursor Variable The OPEN-FOR statement relates a cursor variable with the multi-row query, executes the query, and then identifies the result set. The syntax for ope

Question: Consider the following relations (primary keys are underlined): AUTHOR (ANo, aname, address, speciality) PUBLISHER (PNo, pname, Location) BOOK (BNo, Title, ISBN,

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

Parameter and Keyword Description: record_type_name: This identifies the user-defined type specifier that is used in the subsequent declarations of the records. NOT N

This is a Customer Management project. Customer data is presented in a text file. The program will load this text data into its DB columns. The data mapping is user definable. User

Semidifference via NOT IN and a subquery SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' AND StudentId NOT IN (SELECT StudentId FROM IS_ENROLLED_ON WHER

SELECT a.child_fname,a.child_lname,concat(b.parent_title,b.parent_fname), b.parent_lname,b.parent_tphone FROM child a,parent b WHERE a.parent_id=b.parent_id ORDER BY a.child_fnam

Positional and Named Notation You can write the actual parameters when calling a subprogram, using either positional or named notation. That is, you can point to the relationsh

Package STANDARD The package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available