發表文章

Type-over text (Overtype mode)

Applies To : Project Standard 2007 Excel 2007 Word 2007 Outlook 2007 Access 2007Project 2007 Typing text become overwrite in Word Try to use INSERT key but still not working as expected? Try to disable in option. On the File Menu Click Options Click Advanced Uncheck the option " Use overtype mode " Reference: https://support.office.com/en-us/article/Type-over-text-Overtype-mode-2fe125af-505f-4ce7-bbea-f0e64e381e75?ui=en-US&rs=en-US&ad=US&fromAR=1#bm14

Change the Normal template (Normal.dotm) - Make changes on default word document styles and layout

Applies To : Word 2016 Word 2013 Word 2010 Word 2007 The Normal.dotm template opens whenever you start Microsoft Word, and it includes default styles and customizations that determine the basic look of a document. On the File tab, click Open . Go to C:\Users\ user name \AppData\Roaming\Microsoft\Templates. Open the Normal template ( Normal.dotm ). Make any changes that you want to the fonts, margins, spacing, and other settings. You can use the same commands and features that you use to change a document — but remember that any changes that you make to Normal.dotm will be applied to documents that you create in the future. When you have finished, click the File tab, and then click Save . NOTE : If Normal.dotm is renamed, damaged, or moved, Word automatically creates a new version (which uses the original default settings) the next time that you start Word. The new version will not include any of the customizations that you made to the version that you renamed or move...

FND_GLOBAL.APPS_INITIALIZE

FND_GLOBAL.APPS_INITIALIZE is used for initializing the session before calling any public or private API’s in Oracle Ebusiness suite. Its not required for all the API’s but its recommended that you set this profile before making any calls to either private or public API. Listed below is a sample call to FND_GLOBAL.APPS_INITIALIZE function fnd_global.APPS_INITIALIZE(user_id=>l_user_id,                            resp_id=>l_resp_id,                            resp_appl_id=>l_resp_appl_id); l_user_id is the fnd user ID which will be utilized during the call. l_resp_id is the responsibility ID l_resp_appl_id is the responsibility application ID. You can use either sysadmin or use some user who has all the above listed responsibilities. For SYSADMIN, utilize the following query to get the respective values select fnd.user_id, ...

常見易明既日本地圖 (未計北海道)

圖片
常見易明既日本地圖 (未計北海道)

Move file in Oracle PL/SQL

Here is a example of dynamically define directory in PL/SQL, then use file utility UTL_FILE to move or rename a file. -- Defined DIR SELECT * FROM ALL_DIRECTORIES -- mv file DECLARE   vdir VARCHAR2 (255); BEGIN   vdir := '/source_dir' || '/sub_dir' ;   EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY SRC_DIR AS ''' || vdir || '''' ;      vdir := '/dest_dir'||'/sub_dir';   EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY DEST_DIR AS ''' || vdir || '''' ;      UTL_FILE.FRENAME( 'SRC_DIR' , 'src_filename.ext' , 'DEST_DIR' , 'dest_filename.ext' ); END ;

網上付款費用

最近用信用卡在網上付款,發現原來用渣打的 Master Card 付港幣需付 1% 手續費,付外幣(如美元)則需 1.9% 手續費。 反而用 Visa Card 付港元無需付手續費。 下次要學聰明些,避免無謂收費。

宣傳健康訊息

今早坐火車時,離遠聽到有位女士講電話好大聲,好似重覆地說頭要同肩對齊的健康資料。再過多陣,該女士行到我附近,原來她不是講電話,而係拿住電話,重覆向乘客宣傳要挺直身不要底頭睇電話的訊息。當下有些被她嚇親,因為不知她有否開電話錄影功能錄低乘客樣子,事後回想,感覺應該無錄影,但就唔肯定有無精神問題啦。不論她是否正常人一個,但在車箱內這麼誇張地宣傳訊息,即使訊息本身對人有益,但乘客們的反應是有些怕左佢,而我亦覺得這樣做比較滋擾他人呢。