Oracle SQL: email validation

 Ref:

1.validation on email / postcode fields in sql/oracle

validation on email / postcode fields in sql/oracle - Stack Overflow

2.email validation check with Oracle regular expressions

email validation check with Oracle regular expressions (dba-oracle.com)

Oracle EBS: Shortcut keys

Oracle EBS快捷鍵, 很少在用, 只作參考.

 Ref: 

1.oracle-ebs-shortcut-keys

http://oracleebsfundamentals.blogspot.com/2012/11/oracle-ebs-shortcut-keys.html

Oracle SQL: 檢查email欄位是否有異常字元(II)

隔了幾年再看, 有人提了另一個寫法, 可參考:

 --

SET SERVEROUTPUT ON;

DECLARE

   b_isvalid   BOOLEAN;

BEGIN

   b_isvalid :=

      REGEXP_LIKE ('anyaddress@xyz123.com',

                   '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$');

   IF b_isvalid

   THEN

      DBMS_OUTPUT.put_line ('It is a valid email address.');

   ELSE

      DBMS_OUTPUT.put_line ('It is Not a valid email address.');

   END IF;

END;

/

Ref:

1.Validate Email Using PL/SQL Program

How to Validate Email Address Using PL/SQL? - foxinfotech.in

FTP Script sample

在Windows環境下:

0.取系統年月值

echo %date:~0,4%%date:~5,2%

1.依系統年月建立 folder (c_folder.bat)

if exist c:\c_customs\%date:~0,4%%date:~5,2%\ (echo Yes) else (md c:\c_customs\%date:~0,4%%date:~5,2%\) 

2.批次執行ftp script 並儲存log (c_ftp.bat)

set log=D:\log\%date:~0,4%%date:~5,2%%date:~8,2%.log ftp -s:D:\FTPcmd.txt >> %log%

3.FTP script內容 (FTPcmd.txt)

open ftp_site

v_username

v_password

prompt

cd ftp_folder

lcd local_folder

mget *.pdf

4.刪除單一檔案或多個檔案

delete 123.pdf

mdelete *.pdf

Oracle EBS: reverse GL

 問題: AR transaction錯誤拋轉, 在GL要作reverse

作法:

Setup->Sources

Source:Receivables

Source Key:Receivables

Freeze Journals: 先disable讓User可以reverse