Difference between 9i & 10g, PL-SQL Programming

Difference between 9i & 10G

When Oracle releases any new databases then it are having some discrepancy with them. But 10G is having much difference than oracle 9i has. Oracle 10g is a major rewriting of the Oracle from Oracle 9i.  If we will make a list of the differences then difference Are much which makes a improved database for any database designer. Several hundred new features, graphics have been added besides this other differences between 9i and 10g, are.

 

Posted Date: 3/14/2013 2:15:49 AM | Location : United States







Related Discussions:- Difference between 9i & 10g, Assignment Help, Ask Question on Difference between 9i & 10g, Get Answer, Expert's Help, Difference between 9i & 10g Discussions

Write discussion on Difference between 9i & 10g
Your posts are moderated
Related Questions
Enrolment was split - SQL Example shows how relvars IS_CALLED and IS_ENROLLED_ON can be derived from the original ENROLMENT relvar, using projection in the initial assignment

Architecture The PL/SQL run-time system and compilation is a technology, not an independent product. Consider this technology as an engine that compiles and executes the PL/SQL

to write a heap sort program usin pl-sql

Consider the following set of database tables (same tables from Assignment 6-1). Please take note of foreign keys (most of them carry the same names as the corresponding primary ke

Use the NOCOPY Compiler Hint By default, the OUT and IN OUT parameters are passed by the value i.e. the value of an IN OUT actual parameter is copied into the corresponding fo

Ending Transactions A good quality programming practice is to commit or roll back every transaction explicitly. Whether you rollback or issue the commit in your PL/SQL program

Parameter Default Values As the illustration below shows, you can initialize the IN parameters to the default values. In that way, you can pass various numbers of actual par

Biconditional - SQL The biconditional p ↔ q can be expressed in Tutorial D by p = q and the same is true of SQL. The question then arises as to whether, in SQL, p = q is equiv

Keyword & Parameter Description: PRAGMA: These keywords signify that the statement is a pragma (i.e. compiler directive). The Pragmas are processed at the compile time, n

EXCEPTION_INIT Pragma The pragma EXCEPTION_INIT relates an exception name with an Oracle error number. Which allow you to refer to any internal exception by the name and to wri