SQL & PL/SQL

dear all;

This is just for learning purposes

I have created a simple table below

create table t1
(
  vid varchar2(30),
  quantity number(6,2),
  primary key (vid)
  );
  

insert into t1
    (vid, quantity)
values
    ('G1', 2);
  
insert into t1
    (vid, quantity)
values
    ('G2', 3);
insert into t1
    (vid, quantity)
values
    ('G3', 0);

Now, I would like to create a simple batch job, that runs every month which is used to delete all vid that has a quantity of 0...How do i go about doing that. I have searched the web but can't seems to find any useful info so far..

Edited by: user13328581 on Sep 8, 2010 8:32 AM