Partition Views
From: Mike Isaac <michael.isaac_at_matrikon.com>
Date: Wed, 13 Jan 1999 10:52:21 -0700
Message-ID: <77imeo$kpl13_at_dagger.videotron.ab.ca>
I have a number of tables with names ending with the year.
Date: Wed, 13 Jan 1999 10:52:21 -0700
Message-ID: <77imeo$kpl13_at_dagger.videotron.ab.ca>
I have a number of tables with names ending with the year.
ie: Data_Table_1999, Data_Table_2000, ......
and I want to create a view such that when I insert data into the table, it inserts into the table that corresponds with the current year. Can this be done either using partition views or Unions? Please give me an example.
thanks in advance.
Mike Received on Wed Jan 13 1999 - 18:52:21 CET