在Oracle中实施OOPS [英] Implementation of OOPS in Oracle

问题描述

您能给我一些有关在Oracle中实现OOPS的想法吗?

Can you give me some idea about implementation of OOPS in Oracle?

推荐答案

Oracle从数据库8.0版开始(即十年后)开始支持对象.但是，直到9iR2，Oracle TYPE才支持用户定义的构造函数并正确实现了多态性.在11g中，他们增加了对Java风格的SUPER()调用的支持.但是Oracle仍然不支持私有变量或私有方法.

Oracle has supported objects since version 8.0 of the database (i.e. over a decade). However, it wasn't until 9iR2 that Oracle TYPE supported user-defined constructors and properly implemented polymorphism. In 11g they added support for a Java-esque SUPER() call. But Oracle still doesn't support private variables or private methods.

因此，在Oracle世界中，OO编程并没有真正起飞.人们使用类型在PL/SQL中定义集合，这对于批量处理.流水线函数也很简洁，可以打开一个有趣的小工具集.

As a consequence, OO programming hasn't really taken off in the Oracle world. People use Types to define collections in PL/SQL, which are especially useful for bulk processing. Pipelined functions are also neat, and open up an interesting little toolset.

我已经使用了Oracle的面向对象功能，并且老实说，在很多情况下，与常规PL/SQL相比选择类型有意义.但是，在某些情况下它可能会有用.我已经对此写了一些篇幅. 了解更多信息.

I have used Oracle's object oriented functionality, and if I'm honest there are not many scenarios where it makes sense to choose types over regular PL/SQL. However, there are some situations where it can be useful. I have blogged about this at some length. Find out more.

修改

正如Tuinstoel所说，我链接到Adrian网站上的错误文章.他们正确地划分了我要链接的文章，现在我相应地更改了链接.

As Tuinstoel commented I linked to the wrong article on Adrian's site. They correctly divined the article I meant to link to, and I have now changed the link accordingly.

这篇关于在Oracle中实施OOPS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！