hi,
As far as the new features in 9i are concerend, its a wide range of new keywords, new fundas made in this release. But to mention a few
there are new things in SQL and in PL/SQL
there are new things like
ONline Table redifinition, Resumable tablespaces,
new functions in ranking and all(business intelligence)
introduction to occi along with new htings in oci, also introduction of ODCI(Oracle Data Cartridge Interface)
New version of domain indexes, support for bitmap indexes in detailed manner, support for SQLJ objects , XMLType, with XSQL Servlet, XSLStyleSheet and alll that thing.
In SQL there is a new DML statement, like MErge and one new key term used for subqueries, WITH clause.
Actually not possible to write in one paragraph.
hope this helps u
regards
abhivyakti