Re: REGEXP
From: oracledba <oracledba71_at_gmail.com>
Date: Fri, 13 Sep 2013 09:54:26 -0400
Message-ID: <CA+eRr5GBQndALZKMJ9uJdJBNbPTVDkVNsPJfVw999wcm6qK8bg_at_mail.gmail.com>
Actually i am trying to list out materialized views which are not refreshed based on its interval and next_date and last_date.Since MVs are refreshed at different intervals i need to report when MV refresh is failed. I don't want to use "broken" column for it.Interval in dba_jobs is a varchar column.
Date: Fri, 13 Sep 2013 09:54:26 -0400
Message-ID: <CA+eRr5GBQndALZKMJ9uJdJBNbPTVDkVNsPJfVw999wcm6qK8bg_at_mail.gmail.com>
Actually i am trying to list out materialized views which are not refreshed based on its interval and next_date and last_date.Since MVs are refreshed at different intervals i need to report when MV refresh is failed. I don't want to use "broken" column for it.Interval in dba_jobs is a varchar column.
On Fri, Sep 13, 2013 at 6:28 AM, Sayan Malakshinov <xt.and.r_at_gmail.com>wrote:
> You can do the same without regexp: replace(str,'SYSDATE', 0)
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 13 2013 - 15:54:26 CEST