SELECT OWNER,
OBJECT_TYPE,
OBJECT_NAME,
CREATED,
STATUS
FROM all_objects
WHERE CREATED >= '27-MAY-2013' AND OBJECT_TYPE IN ('TABLE', 'VIEW')
ORDER BY OWNER, OBJECT_TYPE
OBJECT_TYPE,
OBJECT_NAME,
CREATED,
STATUS
FROM all_objects
WHERE CREATED >= '27-MAY-2013' AND OBJECT_TYPE IN ('TABLE', 'VIEW')
ORDER BY OWNER, OBJECT_TYPE
No comments:
Post a Comment