注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

和申的个人主页

专注于java开发,1985wanggang

 
 
 

日志

 
 

Procedures vs. Packages oracle  

2010-09-10 15:32:47|  分类: 数据库 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
Packages are groups of procedures, functions, variables, and SQL statements grouped together
into a single unit. To execute a procedure within a package, you must first list the package name,
and then list the procedure name, as shown in the following example:
execute BOOK_INVENTORY.NEW_BOOK('ONCE REMOVED');
Here, the NEW_BOOK procedure within the BOOK_INVENTORY package was executed.

Packages allow multiple procedures to use the same variables and cursors. Procedures within
packages may be either available to the public (as is the NEW_BOOK procedure in the prior example)
or private, in which case they are only accessible via commands from within the package (such
as calls from other procedures). Examples of packages are shown in “create package Syntax,” later
in this chapter.
Packages may also include commands that are to be executed each time the package is called,
regardless of the procedure or function called within the package. Thus, packages not only group
procedures but also give you the ability to execute commands that are not procedure specific.
See “Initializing Packages,” later in this chapter, for an example of code that is executed each
time a package is called.
  评论这张
 
阅读(742)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2016