目前日期文章:200911 (8)

瀏覽方式: 標題列表 簡短摘要
  • Nov 26 Thu 2009 13:03
  • Chr表

Chr(0)

Null Chr(29) 分组符 Chr(38) & Chr(48) 0
Chr(8) 退格 Chr(30) 記錄分離符號 Chr(39) ' Chr(49) 1
Chr(9) Tab Chr(31) 單元分隔符號 Chr(40) ( Chr(50) 2
Chr(10) 换行 Chr(32) 空格SPACE Chr(41) ) Chr(51) 3
Chr(12) 换页 Chr(33) ! Chr(42) * Chr(52) 4
Chr(13) Enter

Chr(33)

! Chr(43) + Chr(53) 5
Chr(22) 粘贴 Chr(34) " Chr(44) , Chr(54) 6
Chr(26) 撤销 Chr(35) # Chr(45) - Chr(55) 7
Chr(27) Esc Chr(36) $ Chr(46) . Chr(56) 8
Chr(28) 文件分隔符 Chr(37) % Chr(47) / Chr(57) 9
Chr(58) : Chr(68) D Chr(78) N Chr(88) X
Chr(59) ; Chr(69) E Chr(79) O Chr(89) Y
Chr(60) < Chr(70) F Chr(80) P Chr(90) Z
Chr(61) = Chr(71) G Chr(81) Q Chr(91) [
Chr(62) > Chr(72) H Chr(82) R Chr(92) \
Chr(63) ? Chr(73) I Chr(83) S Chr(93) ]
Chr(64) @ Chr(74) J Chr(84) T Chr(94) ^
Chr(65) A Chr(75) K Chr(85) U Chr(95) _
Chr(66) B Chr(76) L Chr(86) V Chr(96) `
Chr(67) C Chr(77) M Chr(87) W Chr(97) a
Chr(98) b Chr(108) l Chr(118) v Chr(128)
Chr(99) c Chr(109) m Chr(119) w
Chr(100) d Chr(110) n Chr(120) x
Chr(101) e Chr(111) o Chr(121) y
Chr(102) f Chr(112) p Chr(122) z
Chr(103) g Chr(113) q Chr(123) {
Chr(104) h Chr(114) r Chr(124) |
Chr(105) i Chr(115) s Chr(125) }
Chr(106) j Chr(116) t Chr(126) ~
Chr(107) k Chr(117) u Chr(127) 删除

SomebabyTina 發表在 痞客邦 PIXNET 留言(3) 人氣()

1.FND_GLOBAL.USERID --Returns userid

2.FND_GLOBAL.APPS_INTIALIZE procedure

  •    APPS_INITIALIZE(user_id in number,resp_id in number,resp_appl_id in number);
       This is used to set the values userid and responsibilityid for a session
    3.FND_GLOBAL.LOGIN_ID -Gives login id
    4.FND_GLOBAL.CONC_LOGIN_ID--Not sure how to use this

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

資料來源: OTN

This tip comes from Navroz Kapadia, DBA, Economics & Business Cluster in Toronto, Ontario, Canada.

This script will generate a SQL*Loader control file for any specified table, which can then be customized as per individual needs. Ensure it is run by a user with SELECT_CATALOG_ROLE. Parameter 1 is the owner of the table. Parameter 2 is the tablename.


set verify off

set heading off

SomebabyTina 發表在 痞客邦 PIXNET 留言(1) 人氣()

image


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

INV: Updateable item name

image


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

這個Case 是為了讓User 於收料畫面方便 Submit Report Request.

設定方式如下:

1. Create New Rule : Trigger Event = When-New-Form-Instance

image

2. Menu Entry :選擇Special16 (Sepcial 16 ~30是”Report”選項)

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

About Global Parameter or Form Personalize you shall know.

  • GLOBAL variables are dynamically created at runtime
  • They can hold up to 255 bytes
  • They are visible across all forms that are currently running

2 Properties affect them:

  • VALUE:

–Creates it if it does not exist

–Always sets the value

  • INITIAL VALUE:

–Creates it if it does not exist, setting it to null

–Only sets the value if it is currently null

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

 

Oracle Form Personalize 提供1~45的Special Menu for us to using.

Each has the name SPECIAL#

–SPECIAL1 though 15: under ‘Tools’

–SPECIAL16 though 30: under ‘Reports’

–SPECIAL31 though 45: under ‘Actions

image

如果要啟用Menu ,Must be activated in a Rule based on the WHEN-NEW-FORM-INSTANCE event

image

image

So you can see new item in your Menu List.

image


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

找更多相關文章與討論