xublogs - 博客园

Oracle之AUTHID CURRENT_USER

摘要：没有AUTHID CURRENT_USER表示定义者权限（definer rights），以定义者身份执行；加上AUTHID CURRENT_USER表示调用者权限（invoker rights），以调用者身份执行。例：1. 创建两个用户：xxpo，xxgl2. 在xxpo下创建一张表：xxpo_authid_testCREATE TABLE xxpo.xxpo_authid_test(ID NUMBER,NAME VARCHAR2(20)); 3. 在xxpo下创建如下两个procedure 3.1 xxpo_no_authid_test_prc： CREATE OR REPLACE P.. 阅读全文

posted @ 2011-05-18 13:49 xublogs 阅读(170) 评论(0) 推荐(0) 编辑

trap or bug when using CONTINUE in Oracle 11g

摘要： CONTINUE is a new featurebroughtin Oracle 11g, but there is a trap or bug need to pay attention, see the following code scrap:DECLARE CURSOR dept_cur IS SELECT deptno ,dname ,loc FROM scott.dept; TYPE dept_tab IS TABLE OF dept_cur%ROWTYPE INDEX BY BINARY_INTEGER; ... 阅读全文

posted @ 2011-05-17 16:56 xublogs 阅读(179) 评论(0) 推荐(0) 编辑

A Simple Example of Weak Ref Cursor

摘要： DECLARE l_sql VARCHAR2(2000) := 'select deptno,loc from scott.dept'; l_where VARCHAR2(200); TYPE dept_curtype IS REF CURSOR; dept_cur dept_curtype; TYPE dept_rec IS RECORD( deptno VARCHAR2(200) --attention the record element order ,loc VARCHAR2(200)); TYPE dept_tbl IS TABL... 阅读全文

posted @ 2011-05-11 11:08 xublogs 阅读(107) 评论(0) 推荐(0) 编辑

SQL to inspect form personalization

摘要： SQL to inspect form personalization:SELECT *FROM fnd_form_custom_rulesWHERE function_name LIKE '%OEXOEORD%'AND description LIKE '%Order Confirmation';SELECT *FROM fnd_form_custom_actionsWHERE rule_id IN (SELECT id FROM fnd_form_custom_rules WHERE function_name LIKE '%... 阅读全文

posted @ 2011-05-10 18:26 xublogs 阅读(81) 评论(0) 推荐(0) 编辑

这个sql咋写？

摘要：这个sql咋写？两个表的结构一模一样，数据大部分是重复，小部分不同；要求：1.如果a列数据相同，计算b列相减的结果test1:a b xxx 1yyy 2zzz 3test2：a bxxx 3zzz 2qqq 1查询结果结果为：a bxxx 2zzz -1yyy -2qqq 1 Create Table:CREATE TABLE test1(a VARCHAR2(20),b NUMBER); CREATE TABLE test2(a VARCHAR2(20),b NUMBER); INSERT INTO test1 VALUES('xxx',1); INSERT INTO te 阅读全文

posted @ 2011-05-04 15:02 xublogs 阅读(123) 评论(0) 推荐(0) 编辑

使用java concurrent调用xmlp api生成pdf

摘要：目的：通过java concurrent调用XML Publisher API处理XML Data Definition和rtf 模板生成PDF报表。环境：Oracle EBS R12.0.4技术：Oracle, Java, XML Publisher步骤：1.创建XML数据定义文件（EmpDataTemplate.xml）并上传至服务器的/home/applprod/test4bip/目录：<?xml version="1.0" encoding="UTF-8" ?> <dataTemplate name="EmpData& 阅读全文

posted @ 2011-04-20 20:14 xublogs 阅读(198) 评论(0) 推荐(0) 编辑

How to Reset or Change Microsoft Office 2007 Product License Key or Volume License Key (VLK)

摘要： You may need to alter or change Microsoft Office 2007 (aka 2007 Microsoft Office System programs and suites) product license key or volume license key (VLK) which also known as serial number or CD key. You can modify or change product key for 2007 Microsoft Office programs or suites by first uninsta 阅读全文

posted @ 2011-04-20 15:48 xublogs 阅读(179) 评论(0) 推荐(0) 编辑

google广告的代码

摘要： <script type="text/javascript"></script><script type="text/javascript"src="http://pagead2.googl 阅读全文

posted @ 2011-04-04 18:41 xublogs 阅读(329) 评论(0) 推荐(0) 编辑

CSS基础

摘要： <p>放在<div>里面内联式样式表直接对html写样式<p style="font-size:50px; color:red">example</p>嵌入式样式表<head><style type="text/css"></style></head><body><p>example</p></body>外部样式表style/ 阅读全文

posted @ 2011-03-22 21:53 xublogs 阅读(119) 评论(0) 推荐(0) 编辑

What is the difference between a pack slip and a pick slip?

摘要： a pack slip denotes what should be "packed" for a delivery. It may consolidate several orders to a route, truck or customer. However, in some businesses the pack slip or packing slip shows what has been "picked" for delivery or shipmenta pick sheet denotes what items to pull from 阅读全文

posted @ 2011-03-16 15:42 xublogs 阅读(171) 评论(0) 推荐(0) 编辑