问题描述
除了许可问题和所有精美的附加软件包之外，从API角度看，Oracle XE和SE之间的真正区别是什么?我的应用程序使用了大量的PL/SQL功能/软件包，但是我无法获得确定哪些有效和无效的最终列表.
Aside from licensing issues and all the fancy add-on packages, what is the real difference between Oracle XE and SE from an API point of view? My application uses a large number of PL/SQL features/packages, and I am unable to get a definitive list of what works and what doesn't.
我已经知道，例如，不包括服务器端Java VM，并且您必须添加一些授权才能获取UTL_FILE.但是UTL_TCP，UTL_SMTP或UTL_RAW呢?诸如数据库触发器(会话登录/注销)或调用外部DLL(EXTPROC)或上下文之类的东西怎么样?您是否知道XE中不可用的其他内容(包，API，系统视图...)?
I already know that, for example, the server-side Java VM is not included, and you have to add some grants to get UTL_FILE. But what about UTL_TCP, UTL_SMTP or UTL_RAW? How about things such as database triggers (session logon/logoff) or calling external DLLs (EXTPROC), or contexts? Do you know anything else (a package, an API, a system view...) that is not available in XE?
我知道我可以尝试安装它，但是我希望有一种更快的方法，例如某些页面列出了相关信息.但是，我发现的只是高级的东西，甚至都没有提到UTL_FILE.
I know that I could just try to install it, but I was hoping for a faster approach, like some page that has a list of the relevant information. However, all I found was high-level stuff that did not even mention UTL_FILE.
推荐答案
Oracle XE包含标准版具有的所有PL/SQL功能和软件包. Oracle白皮书非常清楚什么是并且不包括在内.在早期和更高版本中都使用XE，SE和EE后，您所关心的所有事情都属于白皮书中列出的功能之一.
Oracle XE contains all the PL/SQL features and packages that the standard edition has. The Oracle White Paper is pretty clear on what is and isn't included. Having used XE, SE, and EE for both earlier and later versions all of the the thing you are concerned about fall into one of the features listed in the white paper.
这篇关于Oracle Express Edition(XE)和Standard Edition(SE)之间的PL/SQL API有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！