I'm looking for a way to insert records into a 'black hole'; i.e. execute a query for a certain table successfully, but make the records disappear. Something like INSERT INTO NULL
, if you will. MySQL has the BLACKHOLE engine, can Oracle do something similar?
The only thing I could come up with was:
- creating a view with
SELECT NULL FROM DUAL
- creating a trigger with
INSTEAD OF INSERT
andBEGIN NULL; END;
Is this okay?
Obviously, the optimal way is not to execute the insert statement, but I have no control over this - I have to fix this in the DB.
What's the best way to handle this? (the solution with the least impact on performance)
dual
table. Just create a dummy table instead.