Re: Automic FIFO in Tables?

From: Hans Forbrich <news.hans_at_telus.net>
Date: Mon, 20 Sep 2004 16:23:32 GMT
Message-ID: <8uD3d.94317$XP3.9248@edtnps84>

Caja wrote:

> Hi there,
>
> I heard something about the automatic, configurable deletion of old
> rows in tables in Ora 9i. This should take place in the CREATE TABLE
> syntax.
>
> Does someone knows about that?
> Thanks for any advice!
>
> Carsten

I think you are looking for the Global Temporary Table definition. Either that or Advanced Queues (Oracle's name for message queues) which are implemented as using tables.

Much more detail at htp://docs.oracle.com (and specifically for Oracle9iR2 at http://www.oracle.com/pls/db92/db92.homepage)

If the former, look at the SQL Reference Manual for syntax and details. Also look at Concepts Manual and DB Administrator's Guide for necessary background and conditions.

If Advanced Queueing, I suggest the following docco, in order:

        Concepts
        Application Developer's Guide - Fundamentals
        Application Developer's Guide - Advanced Queuing

/Hans Received on Mon Sep 20 2004 - 11:23:32 CDT