Temp Table's

Hello All,
I use several local temp tables in an application. These tables store
information that is built from some text files by the user. This data
cannot be mixed up by another user logging in at the same time. Is
there a chance that another user can run the app at the same time as
another thus mixing up data? Or is there a new unique temp table
created by the new user? Can someone please explain.

Thanks

Skip wrote:
> Hello All,
> I use several local temp tables in an application. These tables store
> information that is built from some text files by the user. This data
> cannot be mixed up by another user logging in at the same time. Is
> there a chance that another user can run the app at the same time as
> another thus mixing up data? Or is there a new unique temp table
> created by the new user? Can someone please explain.
>
> Thanks

That depends on how you create the temp tables:

#temp is only accessible within the session that created it

##temp is global and accessible by any session