can someone explain this?
select object_name, created, add_months(sysdate, -1)
from all_objects where object_type='DIRECTORY' and CREATED >= add_months(sysdate, -1)
and object_name like '%_CDIR' or object_name like '%_FODIR_%'
order by created asc;
from all_objects where object_type='DIRECTORY' and CREATED >= add_months(sysdate, -1)
and object_name like '%_CDIR' or object_name like '%_FODIR_%'
order by created asc;
gives results of:
SPARKER_1772875_FODIR_3 27-APR-10 08-JUL-11
TROIADA_3027630_FODIR_15 23-AUG-10 08-JUL-11
GREENBM_3027549_FODIR_157 23-AUG-10 08-JUL-11
GREENBM_3027549_FODIR_247 23-AUG-10 08-JUL-11
TROIADA_3027793_FODIR_15 23-AUG-10 08-JUL-11
TROIADA_3043544_FODIR_63 01-SEP-10 08-JUL-11
TROIADA_3044421_FODIR_37 02-SEP-10 08-JUL-11
TROIADA_3064354_FODIR_15 14-SEP-10 08-JUL-11
STAHLSA_3117090_FODIR_32 05-OCT-10 08-JUL-11
STAHLSA_3153466_FODIR_31 12-OCT-10 08-JUL-11
STAHLSA_3153466_FODIR_36 12-OCT-10 08-JUL-11
...
why is dba_objects returning values that should be excluded? i'm coding to return records greater than 1 month ago.
0