生成新單號範例

SELECT SUBSTR(lastPID, 1, 5)||(SUBSTR(lastPID, 6, 8)+1) newPID FROM (
  SELECT nvl(MAX(FAW01),'FA20-'||TO_CHAR(SYSDATE, 'YYMM')||'0000') lastPID
  FROM FAW_FILE
  WHERE FAW01 LIKE 'FA20-'||TO_CHAR(SYSDATE, 'YYMM')||'%'
)