目前日期文章:200805 (10)

瀏覽方式: 標題列表 簡短摘要
可以在form級觸發器“when-tag-page-changed”中加入如下代碼:   
declare
  v_item    varchar2(32);
begin
  v_item:=:system.cursor_item;

oracleD2K 發表在 痞客邦 留言(0) 人氣()

實現方法: 
   1. 在Form級觸發器中加上觸發KEY-OTHERS
   2. 在此觸發器中寫如下程式碼:
      null;
   3. 這樣FORM程序執行後,大部分的功能鍵都被修改(包括一些必需鍵,如:上箭頭、下箭頭、退出...),

oracleD2K 發表在 痞客邦 留言(0) 人氣()

失敗的時候,要移除Oracle
1. 停止所有Oracle服務
2. 刪除 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
3. 刪除 Path 裡所有跟Oracle有關的路徑
4. 刪除\Program Files\Oracle目錄

oracleD2K 發表在 痞客邦 留言(0) 人氣()

  IF    (:KFA010FBU_QF.DEPT_CODE IS NULL)     THEN   
        GO_ITEM('KFA010FBU_QF.DEPT_CODE');
  ELSIF (:KFA010FBU_QF.CATEGORY1 IS NULL)     THEN   
        GO_ITEM('KFA010FBU_QF.CATEGORY1');                   
  ELSE

oracleD2K 發表在 痞客邦 留言(0) 人氣()

beign  
  for rec in(select no2,name from t2) loop  
    update t1   
    set no1=rec.no2 
    where name=rec.name 

oracleD2K 發表在 痞客邦 留言(0) 人氣()

Action                 Trigger Firing Order                    Level
------                 --------------------                    -----
Runform                 1.  Pre-Logon                          Form
                        2.  On-Logon                           Form
                        3.  Post-Logon                         Form
                        4.  Pre-Form                           Form
                        5.  When-Create-Record                 Block
                        6.  Pre-Block                          Block
                        7.  Pre-Record                         Block
                        8.  Pre-Text-Item                      Item
                        9.  When-New-Form-Instance             Form
                        10. When-New-Block-Instance            Block
                        11. When-New-Record-Instance           Block
                        12. When-New-Item-Instance             Item
***********

Enter Query             1.  Post-Text-Item                     Item
                        2.  Post-Record                        Block
                        3.  When-Clear-Block                   Block
                        4.  When-New-Record-Instance           Block
                        5.  When-New-Item-Instance             Item
Note: If you define the Key-ENTQRY trigger, this is the only trigger
      which fires in an Enter Query situation.
*****************
Execute Query
After Enter Query       1.  Pre-Query                          Block
                        2.  Pre-Select                         Block
                        3.  On-Select                          Block
                        4.  When-Clear-Block                   Block
                        5.  Post-Select                        Block
                        6.  On-Fetch                           Block
                        7.  On-Close                           Form
                        8.  When-Clear-Block                   Block
Note: If you define the Key-EXEQRY trigger, this is the only trigger
      which fires in an Execute Query situation.
*************
Execute Query
Without Enter
Query                   1.  Post-Text-Item                     Block
                        2.  Pre-Query                          Block
                        3.  Pre-Select                         Block
                        4.  On-Select                          Block
                        5.  Post-Select                        Block
                        6.  On-Fetch                           Block
                        7.  On-Close                           Form
                        8.  When_Create_Record                 Block
                        9.  Pre-Record                         Block
                        10. Pre-Text-Item                      Item
                        11. When-New-Record-Instance           Block
                        12. When-New-Item-Instance             Item
****
Exit                    1.  Post-Text-Item                     Item
                        2.  Post-Record                        Block
                        3.  Post-Block                         Block
                        4.  Post-Form                          Form
                        5.  On-Rollback                        Form
                        6.  Pre-Logout                         Form
                        7.  On-Logout                          Form
                        8.  Post-Logout                        Form
**************
Next Field and
Previous field          1.  When-New-Item-Instance             Item
***************
Next Record and
Previous Record         1.  When-New-Record-Instance           Block
                        2.  When-New-Item-Instance             Item
**************
Next Block and
Previous Block          1.  Post-Text-Item                     Item
                        2.  Post-Record                        Block
                        3.  Post-Block                         Block
                        4.  When-Create-Record                 Block
                        5.  Pre-Block                          Block
                        6.  Pre-Record                         Block
                        7.  Pre-Text-Item                      Block
                        8.  When-New-Block-Instance            Block
                        9.  When-New-Record-Instance           Block
                        10. When-New-Item-Instance             Form
*******************
Records Are Queried     1.  Post-Query                         Block
                        2.  Post-Change                        Block
                        3.  Post-Change                        Item
                        4.  Post-Change                        Block
                        5.  Post-Change                        Block
                        Go back to Post-Query
NOTE: This cycle is repeated for each record retrieved.
**********************
No Records Are Queried  1.  When-New-Record-Instance           Block
                        2.  When-New-Item-Instance             Item
NOTE: To observe this Trigger Firing Order:
        a.  Enter a query.
        b.  Enter a nonexistent record.
        c.  Execute the query.
      The two triggers listed above, the Enter Query triggers, and
      the Execute Query triggers fire.
*************
Create Record           1.  Post-Change                         Block
                        2.  When-Validate-Item                  Block
                        3.  Post-Text-Item                      Block
                        4.  When-Validate-Record                Block
                        5.  Post-Record                         Block
                        6.  Post-Block                          Block
                        7.  On-Savepoint                        Form
                        8.  Pre-Commit                          Form
                        9.  Pre-Insert                          Block
                        10. On-Insert                           Form
                        11. Post-Insert                         Block
                        12. Post-Forms-Commit                   Form
                        13. On-Commit                           Form
                        14. Post-Database-Commit                Form
                        15. Pre-Block                           Block
                        16. Pre-Record                          Block
                        17. Pre-Text-Item                       Block
                        18. When-New-Item-Instance              Form
*************
Update Record           1.  When-Database-Record                Block
                        2.  Post-Change                         Block
                        3.  When-Validate-Item                  Block
                        4.  Post-Text-Item                      Block
                        5.  When-Validate-Record                Block
                        6.  Post-Record                         Block
                        7.  Post-Block                          Block
                        8.  On-Savepoint                        Form
                        9.  Pre-Commit                          Form
                        10. Pre-Update                          Block
                        11. On-Update                           Block
                        12. Post-Update                         Block
                        13. Post-Forms-Commit                   Form
                        14. On-Commit                           Form
                        Here the transaction is complete and one record added.
                        15. Post-Database-Commit                Form
                        16. Pre-Text-Item                       Block
                        17. When-New-Item-Instance              Form
NOTE: To observe this Trigger Firing Order:
        a.  Execute a query.
        b.  Change a value.
        c.  Choose Action->Save from the menu.
        d.  Record the triggers from that point.
*************
Delete Record           1.  On-Lock                             Block
                        2.  When-Remove-Record                  Block
                        3.  Post-Change                         Block
                        4.  Post-Change                         Block
                        5.  Post-Change                         Block
                        6.  Post-Change                         Block
                        7.  Post-Change                         Block
                        8.  Post-Change                         Block
                        9.  Post-Change                         Item
                        10. Post-Query                          Block
                        11. Post-Text-Item                      Block
                        12. Post-Record                         Block
                        13. Pre-Record                          Block
                        14. Pre-Text-Item                       Block
                        15. When-New-Record-Instance            Block
                        16. When-New-Item-Instance              Form
NOTE: To observe this Trigger Firing Order, delete a detail record.

oracleD2K 發表在 痞客邦 留言(0) 人氣()

       decode(sign(rgd.acctd_amount),1,rgd.acctd_amount,null) dr
       ,decode(sign(rgd.acctd_amount),-1,rgd.acctd_amount*-1,null) cr

oracleD2K 發表在 痞客邦 留言(0) 人氣()

 一、處理錯誤
 
1.當錯誤出現在Oracle Form PL/SQL中時,處理的方法如下: 
 IF (err_condition) THEN  
    Fnd_message.set_name(appl_short_name,message_name); 

oracleD2K 發表在 痞客邦 留言(0) 人氣()

PACKAGE BODY F_CURSOR IS

  --當鼠標指針改變為插入光標位于文本項時的正常形狀
  PROCEDURE CUR_DEFAULT IS
  BEGIN       
    SET_APPLICATION_PROPERTY(CURSOR_STYLE,'DEFAULT');    

oracleD2K 發表在 痞客邦 留言(0) 人氣()

序號
1 增加用戶參數p_row_no,初始值為0

2 增加一個公式列CF_NO,在公式列的PL/SQL程序中這樣寫:
function CF_NOFormula return Number is
begin

oracleD2K 發表在 痞客邦 留言(0) 人氣()