PL/SQL常用脚本5

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';