What is the difference between Oracle 10g and 11g?

By [)ia6l0 iii

11g provides the following new features over 10g

a) Enhanced automatic memory management of the System global and the Program Global Areas
b) Result Cache - New memory component is added to store queries which are used frequently
c) A Diagnostic infrastrucuture is added to diagnose critical database errors
d) Virtual columns are added.

Related FAQs

This is extremely useful function when you want to display number of characters depending on some column value.
Normalization in databases refers to representing data in a manner with least representation so that its accessible in all the ways.
You will get this SQL Connection error, if your SQL Server is not configured to use SQL Server authentication. You need to enable mixed mode authentication to enable both Windows and SQL Server authentication mechanisms.
The error means that you attempted to truncate a table with unique/primary key that is referenced as foriegn key in another table.
You can now do the inline variable assignment in SQL Server 2008.
User Defined functions can be used inside a Select clause or a conditional statement such as Case. It can also be used in filtering statements such as Where. User Defined functions need to return a value, where as Stored procedures may not return. Stored are pre-compiled unlike the functions that are compiled at runtime.
What is the difference between Oracle 10g and 11g?  (6900 Views)