来自:百度知道
SELECT *
FROM ALL_OBJECTS
WHERE TO_CHAR(CREATED, 'yyyymmdd') = TO_CHAR(SYSDATE, 'yyyymmdd')
AND OBJECT_TYPE = 'TABLE';
来自:百度知道
SELECT *
FROM ALL_OBJECTS
WHERE TO_CHAR(CREATED, 'yyyymmdd') = TO_CHAR(SYSDATE, 'yyyymmdd')
AND OBJECT_TYPE = 'TABLE';