Subject Re: [firebird-support] Temporary sets of data
Author Mr. John
Thanks so much Thomas !

From: Thomas Steinmaurer <ts@...>
Sent: Monday, November 26, 2012 8:46 PM
Subject: Re: [firebird-support] Temporary sets of data

> Hi,I use FB 2.5 !
> I'm writing a store procedure,and there I need some sets of data stored temporary to use only in my SP,I also need to update/delete it
> Is there is a easy way to do this with firebird?
> I also found there are temporary tables,but I don't know how to use or if is what I need.

Yes, there are global temporary table (GTT). You have to define and
create a GTT like any other table and metadata are globally visible, but
the scope of the data is bound to a transaction or a connection.

More on GTT is available here:

With regards,
Thomas Steinmaurer

[Non-text portions of this message have been removed]