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
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

I want someone to write a TSQL function that returns the name of the ODBC DSN. I will use the queries below, to get information about the connection, but none of these return th

Structure of an Object Type: Similar to package, an object type has 2 parts: the specification and the body. The specification is the interface to your applications; it declar

Use of Table Comparisons - SQL Table comparisons where it is noted that although table expressions cannot be compared, we have TABLE (t) to convert a table expression t into

Dynamic Ranges The PL/SQL lets you determine the loop range dynamically at run time, as the example below shows: SELECT COUNT(empno) INTO emp_count FROM emp; FOR i IN 1..emp_cou

EXECUTE Privilege To call an invoker-rights routine straightforwardly, the users should have the EXECUTE privilege on that routine. By yielding the privilege, you permit a user

Datatype Conversion At times it is necessary to convert a value from one datatype to another. For e.g. if you want to inspect a rowid, you should convert it to a character stri

Count Operator in SQL Example: Counting the students who have scored more than 50 in some exam (SELECT COUNT (*) FROM (SELECT DISTINCT StudentId FROM EXAM_MARK WHE

Collection Methods:   The collection method is a built-in function or procedure which operates on the collections and is called using the dot notation. The methods like the C

What are 3 good practices of modeling and/or implementing data warehouses?