Re: Yearly Automatic Table Insertion

On 19 Mar 2004 09:51:50 -0800, mwagner_at_mail.dot.state.de.us (mw) wrote:

>I have a table called years in my database that is used for populating
>a year dropdown list on various end user web forms. I'm looking for a
>solution for automatically adding the next year to this table at a
>specified date, once a year, on a recurring yearly basis (i.e. every
>December 1st, the next year is automatically added to the years
>table). The application is a java web application, using
>CallableStatements to execute plsql packages, functions, etc on the
>database side. It may be distributed to many clients. I thought of
>creating stored procedure, then scheduling it thru dbms_job to run
>once a year. Is there a better solution? What would be the most
>efficient way to do this?

Inserting one row into one table once a year .. . . who cares about the most efficient way to do it? You've already spent more time writing your question than even the most IN-efficient method will cost within your grandchldren's lifetime! ;-)

Use dbms_job. Received on Fri Mar 19 2004 - 12:30:24 CST