![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
teacher3010
这个作者很懒,什么都没留下…
展开
-
PACKAGE
oracle sample schema 'HR' & 'SCOTT' locate at :http://code.google.com/p/adf-samples-demos/downloads/detail?name=demoscripts.zip&can=2&q=1. Package(Package is simply a collection of...2013-03-13 15:17:14 · 116 阅读 · 0 评论 -
oracle wrap
Wrapping is the process of hiding PL/SQL source code. Wrapping helps to protect your source code from business competitors and others who might misuse it.You can wrap PL/SQL source code with either...原创 2013-03-13 15:45:11 · 93 阅读 · 0 评论 -
trigger
Triggers are procedures that are stored in the database and are implicitly run, or fired, when something happens.Traditionally, triggers supported the execution of a PL/SQL block when an INSERT, U...2013-03-13 16:22:04 · 82 阅读 · 0 评论 -
oracle delete all object under an user
BEGINFOR cur_rec IN(SELECT object_name, object_type FROM user_objects WHERE object_type IN('TABLE','VIEW','PACKAGE','PROCEDURE','FUNCTION','SEQUENCE', ...原创 2013-11-22 11:36:54 · 146 阅读 · 0 评论