Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: /dev/null for Oracle?
My mistake, I missed the INSERT part in my haste.
Sorry about the confusion,
Peter
On Mon, 22 May 2000, Jan Benjamins wrote:
> Please, insert some rows and then
> select sysdate from dual;
>
>
> :)
>
> jan
>
> Peter Connolly <peter_at_wpi.edu> wrote in message
> news:Pine.OSF.4.21.0005221117110.23350-100000_at_wpi.WPI.EDU...
> > You could create a view on top of the dual table.
> >
> > Create view my_dev_null as
> > select dummy col1,
> > dummy col2...
> > from dual
> >
> > This would allow you to delete the actual table and should give quick
> > response.
> >
> > HTH,
> > Peter
> > Lifetime Intern
> >
> >
> >
> > On Mon, 22 May 2000, Peter Dickmann wrote:
> >
> > > Hello,
> > >
> > > I want to get rid of a table which is filled (but never used) by an
> > > application I cannot change. How can I redirect the insert statements to
> > > '/dev/null' ? Would be an 'INSTEAD OF' trigger a solution?
> > >
> > > Thanx, Peter
> > >
> > >
> > >
> >
> >
>
>
>
Received on Mon May 22 2000 - 00:00:00 CDT