Wednesday 19 June 2013

Custom Table

  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

No comments:

Post a Comment