寫一個Oracle 函式提取如下字串中:$PROFILES$.MFG_ORGANIZATION_ID、:$FLEX$.GBINV_ACCOUNT_TYPE、:$FLEX$.GB_START_DATE和:$FLEX$.GB_END_DATE等等字串,回傳陣列
Where mmt.transaction_id in (select max(mmt2.transaction_id)
from mtl_material_transactions mmt2
where mmt2.organization_id = :$PROFILES$.MFG_ORGANIZATION_ID
and mmt2.transaction_type_id = :$FLEX$.GBINV_ACCOUNT_TYPE
And MMT2.Transaction_Date >= To_Date(:$FLEX$.GB_START_DATE,'YYYY/MM/DD')
And MMT2.Transaction_Date < To_Date(:$FLEX$.GB_END_DATE,'YYYY/MM/DD')+1
and mmt.attribute1 = mmt2.attribute1
and mmt2.attribute1 is not null)
uj5u.com熱心網友回復：
這個用java的已經幫你實作了轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/104830.html
標籤：開發