> I have never created a "temp table" before, because I was not sure when
> the table was available and if or when it would be automaticly dropped.
>
> Could someone let me know becuase I could probaly use them in data
> massaging routines.
Temp tables are alive in the current session only. Once the session is
closed, the temp tables created in that session are dropped.
regards,
bhuvaneswaran