Re: [GENERAL] temp table question

2008-02-01 Thread Scott Marlowe
On Feb 1, 2008 9:06 PM, Kevin Kempter <[EMAIL PROTECTED]> wrote: > Hi list; > > If I create a temp table (i.e. create temp table xyz as select from ...) is > the scope of this table limited to a session. Meaning, can several sessions > all run the above create temp table statement all referencing

Re: [GENERAL] temp table question

2008-02-01 Thread brian
Kevin Kempter wrote: Hi list; If I create a temp table (i.e. create temp table xyz as select from ...) is the scope of this table limited to a session. Meaning, can several sessions all run the above create temp table statement all referencing the same temp table name at the same time? Yes

[GENERAL] temp table question

2008-02-01 Thread Kevin Kempter
Hi list; If I create a temp table (i.e. create temp table xyz as select from ...) is the scope of this table limited to a session. Meaning, can several sessions all run the above create temp table statement all referencing the same temp table name at the same time? Thanks in advance ---