Re: Dynamic views

[Arup Nanda]

Title: Dynamic views

Sure, You can write an INSTEAD OF trigger on the view that inserts into the right table.   Arup Nanda www.proligence.com ----- Original Message ----- From: david hill To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 20, 2002 1:48 PM Subject: Dynamic views Hi Guys I'm trying to see if I can get around paying oracle $50,000 for partitioning I have a huge table and I want to partition it on date so I created 12 tables AAAA_JAN AAAA_FEB And so on But I want to create a view that will be used for inserting so it always Points to the current month without having to recreate the view every month. Is there anyway anybody can think of doing this? Thanks David Hill DBA Le Chateau