Jump to content
will71110

Is there a way to reset an entire column to zero using Oracle SQL Express 11g

Recommended Posts

Hello all, This is my first posting on the forums. Here is my question: I want to reset an entire column to zero monthly. Is the possible using Oracle SQL Express 11g? I looked for a way to do it in the Oracle SQL Developer, but I didn't find away to easily do it there. This is for a school project. One of the columns in the table is called monthly sales. That is the column that I want to reset to zero on the 1st of the month. Thanks in advance if anyone can answer this for me.

Share this post


Link to post
Share on other sites

Is there away to do this automatically when a new month begins? I was told a trigger could do it, but this trigger would run every time there is an update to the cell. I don't think that is a very good way to accomplish this as it could cause a lot of overhead.

Share this post


Link to post
Share on other sites

A trigger would be the way to do it if you're only using a database. Or else you could use a scheduled task or cron job to run on a schedule and check for things that need to be updated.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...