![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
plsql
DetaiKong
PassionCreation
展开
-
oracle VPD
---查看对象是否附加有vpdSELECT * FROM dba_policies WHERE object_name LIKE 'MTL_SE%';---Eable 对象的vpd策略BEGIN dbms_rls.enable_grouped_policy(object_name => 'MTL_SECONDARY_INVENTORIES',原创 2015-12-21 22:12:38 · 529 阅读 · 0 评论 -
Oracle EBS 供应商分行创建
DECLARE l_return_statusVARCHAR2(1); l_msg_count NUMBER:=0; l_msg_data VARCHAR2(4000); l_msg_index NUMBER; /*******************客户化内容开始***********************原创 2016-05-24 15:04:34 · 1306 阅读 · 0 评论