Re: 15th of every month for jobs running

?

HansF wrote:
> On Fri, 09 Sep 2005 10:39:00 -0700, jwa6 interested us by writing:
>
> > 'trunc(add_month(sysdate,1))+1­5+(7/48)'
> > end;
> >
> >
> > ORA-06550: line 5, column 17:
> > PLS-00201: identifier 'ADD_MONTH' must be declared
> > ORA-06550: line 5, column 1:
> > PL/SQL: Statement ignored
>
> http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/functions004.htm#sthref1072
>
> --
> Hans Forbrich
> Canada-wide Oracle training and consulting
> mailto: Fuzzy.GreyBeard_at_gmail.com
> *** I no longer assist with top-posted newsgroup queries ***
Received on Mon Sep 12 2005 - 12:49:25 CDT