ITPub博客

http://www.itpub.net/thread-1051167-1-1.html实现四则运算的一条sql语句1.建立一个测试表 create table mar_test( id number, text varchar2(200)) insert into mar_Test values ( 1,'12+556-543*152/2423+23*2*435+34-234'); insert into mar_Test values ( 2,'12/2/3/4'); insert into mar_Test values ( 3,'1*2*34'); insert into mar_Test values ( 4,'1+5-5*2/5+3*2*4*5+34-2'); select a.id,max(text) text, sum(regexp_substr(add_text,'[0-9]+',1,n)*decode(regexp_substr('+'||add_text,

FORMS开发中FOLDER（文件夹）功能的应用[@more@]一、模板制作：YSFOLDER.FMB打开TEMPLATE.FMB，如果打开的是APPSTAND.FMB，以下步骤省略：1、FORM级触发器：1、 在WHEN-NEW-FORM-INSTANCE后面添加以下代码：--定义文件夹数据块app_folder.define_folder_block( object_name => ' DETAILBLOCK _FOLDER' ,folder_block_name => 'DETAILBLOCK',prompt_block_name => 'DETAILBLOCK_PROMPT',folder_canvas_name => 'DETAILBLOCK_STACKED',folder_window_name => 'BLOCKNAME',disabled_functions => '');--以上参数均为VARCHA

hei hei[@more@]Trace a Concurrent Request And Generate TKPROF FileOctober 5, 2008 · 1 CommentHello Friends, As in Oracle Application, there always need to tune programs , procedure and it is always difficult to make a perfect program, here i am trying to put a “How to” on tkprof and surely like to know if you find it useful.How to Trace a Concurrent Request And Generate TKPROF FileEnable Tracing For The Concurrent Manager Program Responsibility: System Administrator Navigate: Concurrent >

关于FND_REQUEST.SUBMIT_REQUEST和 FND_CONCURRENT.WAIT_FOR_REQUEST =========================================================== 作者: slim119(http://slim119.itpub.net)发表于: 2007.05.16 12:11分类: Oracle EBS 出处: http://slim119.itpub.net/post/2106/288064--------------------------------------------------------------- [@more@]--- 提交处理事务处理接口请求l_request_id := FND_REQUEST.SUBMIT_REQUEST(APPLICATION => 'INV',PROGRAM => 'INCTCM');IF ( l_request_id = 0 ) THENRAISE E_SUBMIT_FAILED;RETURN;

通过实例简要介绍case函数的用法。[@more@]1.创建测试表:　　　　DROP SEQUENCE student_sequence;　　CREATE SEQUENCE student_sequence　START WITH 10000　INCREMENT BY 1;　　　　DROP TABLE students;　　CREATE TABLE students (　　id　　　　　　　 NUMBER(5) PRIMARY KEY,　　first_name　　　 VARCHAR2(20),　　last_name　　　　VARCHAR2(20),　　major　　　　　　VARCHAR2(30),　　current_credits　NUMBER(3),　　grade　　　　　　varchar2(2));　　　　INSERT INTO students (id, first_name, last_name, major, current_

Oracle Applications Interface Programs[@more@]Order Import Interface (Sales Order Conversion)Interface tables:· OE_HEADERS_IFACE_ALL · OE_LINES_IFACE_ALL · OE_ACTIONS_IFACE_ALL · OE_ORDER_SOURCES · OE_CUSTOMER_INFO_IFACE_ALL · OE_PRICE_ADJS_IFACE_ALL · OE_PRICE_ATTS_IFACE_ALLBase tables: · OE_ORDER_HEADERS_ALL · OE_ORDER_LINES_ALLPricing tables · QP_PRICING_ATTRIBUTESDuring import of orders, shipping tables are not populated.If importing customers together with the order, OE_ORDER_CUST

http://sbgl.com.cn/101/html/?37.html[@more@]

最近兩個月USER偶爾指出一些報表無法RUN，出現ERROR。提示說：ORA-01722: invalid number[@more@]經排查發現是客戶檔中的CUSTOMER_NUMBER的條件出問題。我之前都習慣用： ar_customer.customer_number in (1666,1667)這樣子。我將其改為ar_customer.customer_number in ('1666','1667')就OK了。這可能是DBA最近上了某個PATCH後，ERP裡不再自動轉換。因為在TOAD裡或REPORT BUILD中，不帶單引號也能正常。隻在ERP環境下有此問題。以後對非NUMBER型的字段還是要加單引號了。以免造成不必要的後果。

這兩天多個ORG出現了同樣的問題。就是在分配DELIVERY_ID時，提示：Error: The action can not be performed becasuse the selected recoreds could not be locked.[@more@]看到這個提示後，就查相關的TABLE 是不是LOCKED了，如：oe_order_lines_all,wsh_delivery_details,wsh_delivery_detail_assignments等，對該LINE做UPDATE都正常。証明沒有被LOCKED。後來無意中發現中WSH_DELIVERY_DETAILS中的ITEM_DESCRIPTION多了一個空格。把此空格去掉後，居然就可以分配DELIVERY_ID了。問題雖然解決了，但對造成這個問題的原因依然未找到。