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
Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server

Opening a Cursor Opening the cursor executes the query & identifies the result set that consists of all rows that meet the query search criteria. For the cursors declared usin

Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Second Step at defining type SID in SQL CREATE TYPE SID AS VARCHAR(5) ; Explanation: TYPE SID announces that a type named SID is being defined to the system.

Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

SQL Pseudocolumns The PL/SQL recognizes the following SQL pseudocolumns, that returns the specific data items: LEVEL, NEXTVAL, CURRVAL, ROWID, & ROWNUM. The Pseudocolumns are n

Keyword &Parameter Description: index_name: This is an undeclared identifier which can be referenced only within the FORALL statement and only as the collection subscript

Use Serially Reusable Packages To help you to manage the use of memory, the PL/SQL gives the pragma SERIALLY_ REUSABLE that mark some packages as serially reusable . So mark

Scope and Visibility The References to an identifier are resolved according to its visibility and scope. The scope of an identifier is that area of a program unit (subprogram, b

Using ROLLBACK The ROLLBACK statements end the present transaction and undo any change made during the transaction. The Rolling back is helpful for two reasons. Firstly, if yo