1、查找EBS各模块的表结构
SELECT *
FROM USER_OBJECTS UO
WHERE UO.OBJECT_NAME like '%CUSTOM%'
AND UO.OBJECT_NAME like 'AR%'
2、检索日期方法
SELECT *
FROM FND_FLEX_VALUES_VL FFVV
WHERE FFVV.LAST_UPDATE_DATE > date '2012-4-23';
1、查找EBS各模块的表结构
SELECT *
FROM USER_OBJECTS UO
WHERE UO.OBJECT_NAME like '%CUSTOM%'
AND UO.OBJECT_NAME like 'AR%'
2、检索日期方法
SELECT *
FROM FND_FLEX_VALUES_VL FFVV
WHERE FFVV.LAST_UPDATE_DATE > date '2012-4-23';