Oracle 8 Oracle 9 version

Answer 1

Oracle Fusion Financials Online Training, Rainbow Training Institute having best instructors for Oracle Fusion Financials Online training and it is well known for providing all

Kinds of oracle fusion technologies through online and it is stepping forward in providing best Oracle Cloud Financials Online Training in Hyderabad, Bangalore, Chennai, Noida, Delhi, USA, UK, UAE, Saudi, Europe, India, Canada. Complete Suite of oracle fusion

financials training videos.

Answer 2

Oracle 8i, Features * PL/SQL Server Pages (PSP's) * DBA Studio Introduced * Statspack * New SQL Functions (rank, moving average) * ALTER FREELISTS command (previously done by DROP/CREATE TABLE) * Checksums always on for SYSTEM tablespace allowing many possible corruptions to be fixed before writing to disk * XML Parser for Java * New PLSQL encrypt/decrypt package introduced * User and Schemas separated * Numerous Performance Enhancements Oracle 9i Features * Scrolling cursor support. Oracle9i allows fetching backwards in a result set. * Dynamic Memory Management - Buffer Pools and shared pool can be resized on-the-fly. This eliminates the need to restart the database each time parameter changes were made. * On-line table and index reorganization. * VI (Virtual Interface) protocol support, an alternative to TCP/IP, available for use with Oracle Net (SQL*Net). VI provides fast communications between components in a cluster. * Build in XML Developers Kit (XDK). New data types for XML (XMLType), URI's, etc. XML integrated with AQ. * Cost Based Optimizer now also consider memory and CPU, not only disk access cost as before. * PL/SQL programs can be natively compiled to binaries. * Deep data protection - fine grained security and auditing. Put security on DB level. SQL access do not mean unrestricted access. * Resumable backups and statements - suspend statement instead of rolling back immediately. * List Partitioning - partitioning on a list of values. * ETL (eXtract, transformation, load) Operations - with external tables and pipelining. * OLAP - Express functionality included in the DB. * Data Mining - Oracle Darwin's features included in the DB.

Answer 3

Latest version Of ORACLE is Oracle 11g till date(1-nov-08)