Related Entries

Useful SQL*Plus headers
Dino eats frog
Oracle with Active Record
When is he free?
Gentle dive into analytic functions

« Introduction to Oracle data dictionary
» Uncivil commision

Inheritance in Oracle 9i

Good article if you want to know what more have been crammed into Oracle 9i, for OOP.

O'ReillyNet: “Steven Feuerstein, coauthor of Oracle PL/SQL Programming, 3rd Edition, offers a quick review of object types and then shows how you can build "object type hierarchies" by taking advantage of inheritance.”

Personally, I think Oracle is adding way too many features no body wants to use. Object-relational database is a good thing, but adding too many new features which seem to lack quality documentation and tool support, not to mention stability issues is probably not the way to go.

Anyway, this article is about how 9i improves on the promise of object-relational database programming. In that aspect, it indeed delivers. PL/SQL programming might get a bit more sensible with these features.

I keep wondering what would it take to add Python support to Oracle. Like how you can create stored procedures in Java. May be Jython can be used to compile stored procedure code into Java classes.

  1. good article

    Posted by: Amit on July 28, 2003 09:42 AM