Whats the correct way of creating and referring to temporary tables in oracle
1. I would like to use
Create Temporary Table TableName As select...
is that the right syntax ?
2. and then refer to it in a query which joins to permanent tables...
select a.field1, b.field2
from table1 a inner join temporary.table2 b on a.field1 = b.field1
3. If I want to refer to a temp table from another connection is that possible ?
4. Whats the difference between a global temp table and a normal one ?
Whats the right syntax and best practice ? We wouldn't know in advance what the users temporary tablespace is called.