A lot of differences this
is my take on them:
8i -> 9i - Real Application Clusters, PL/SQL enhancements, XMLType enhancements
9i -> 10g - ASM space management, tracing and diagnostics, DML error logging, async commit, more PL/SQL changes, table/column encryption, restore points
10g -> 11g - Probably best to point you to technet on that one.
8i -> 9i - Real Application Clusters, PL/SQL enhancements, XMLType enhancements
9i -> 10g - ASM space management, tracing and diagnostics, DML error logging, async commit, more PL/SQL changes, table/column encryption, restore points
10g -> 11g - Probably best to point you to technet on that one.
Data mining
functionalities are also introduced in Oracle 10g Release 2.
Of course, there's flashback database/table/query functionalities. If you have it setup, you can rewind your database, undrop you tables, or query as of X minutes ago.
Regular expression support. Now you are able to use regular expression in your SQL
Merge functionality, it allows update, insert, or both. In addition, it also allows deletion during update.
This is just to name a few. Check out the Oracle 10g new features document.
Of course, there's flashback database/table/query functionalities. If you have it setup, you can rewind your database, undrop you tables, or query as of X minutes ago.
Regular expression support. Now you are able to use regular expression in your SQL
Merge functionality, it allows update, insert, or both. In addition, it also allows deletion during update.
This is just to name a few. Check out the Oracle 10g new features document.
Hioralce 10g is higher
version of oracle 9i, oracle 10g has added a following
features
Transparent Data Encryption Async commits CONNECT ROLE can not only connect Passwords for DB Links are encrypted New asmcmd utility for managing ASM storage Grid computing - an extension of the clustering feature (Real Application Clusters) Manageability improvements (self-tuning features) Performance and scalability improvements Automated Storage Management (ASM) Automatic Workload Repository (AWR) Automatic Database Diagnostic Monitor (ADDM) Flashback operations available on row, transaction, table or database level Ability to UNDROP a table from a recycle bin Ability to rename tablespaces Ability to transport tablespaces across machine types (E.g Windows to Unix) New 'drop database' statement New database scheduler - DBMS_SCHEDULER DBMS_FILE_TRANSFER Package Support for bigfile tablespaces that is up to 8 Exabytes in size Data Pump - faster data movement with expdp and impdp.
Transparent Data Encryption Async commits CONNECT ROLE can not only connect Passwords for DB Links are encrypted New asmcmd utility for managing ASM storage Grid computing - an extension of the clustering feature (Real Application Clusters) Manageability improvements (self-tuning features) Performance and scalability improvements Automated Storage Management (ASM) Automatic Workload Repository (AWR) Automatic Database Diagnostic Monitor (ADDM) Flashback operations available on row, transaction, table or database level Ability to UNDROP a table from a recycle bin Ability to rename tablespaces Ability to transport tablespaces across machine types (E.g Windows to Unix) New 'drop database' statement New database scheduler - DBMS_SCHEDULER DBMS_FILE_TRANSFER Package Support for bigfile tablespaces that is up to 8 Exabytes in size Data Pump - faster data movement with expdp and impdp.