Quote Originally Posted by Queyon
I want to create a global temporary table but don't want to get any table name confict.
If you create a GTT you only do it once and and any name conflict you'd resolve then. GTT avoids the need to create a name dynamically.