包和相关的oops [英] Package and associated oops

问题描述

有谁能告诉我对Package和相关oops的清晰理解。

Can anyone tell me the clear understanding of Package and related oops.

推荐答案

您是否使用Google进行搜索？

< a href =http://docs.oracle.com/cd/B10500_01/appdev.920/a96624/09_packs.htm> PL / SQL包 [ ^ ]

有关更多信息，请阅读Oracle文档&安培;使用谷歌获得更多结果。



简单来说，包捆绑了程序，函数等等（像.NET类中的函数，过程）。

例如，您已编写存储过程&以下函数：

Did you search using Google for that?
PL/SQL Packages[^]
For more things, read Oracle documentations & use Google for more results.

In simple words, Packages bundles things like procedures, functions etc.,(Like functions, procedures in .NET class).
For example, you have written storedprocedures & functions for following things:

Usp_EmployeeInsert
Usp_EmployeeUpdate
Usp_EmployeeDelete
Usp_EmployeeSelect
Usp_EmployeeSelectAll

fn_IsEmployeeIDExists
fn_ISEmployeeActive

现在你可以为上面的东西创建一个包 pkg_EmployeeOperation ，这很容易导航和放大;维护。

创建包后，你可以直接调用该包的子东西。看看例子。

Now you may create a package pkg_EmployeeOperation for above things which is easy to navigate & maintain.
After creating package, you could call the child thing of that package directly. See the example.

call pkg_EmployeeOperation.Usp_EmployeeDelete(.......)

看，多么容易！就是这样。

Look, how easy! that's it.

这篇关于包和相关的oops的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！