In PostgreSQL, the structure and the content of a temp table is local for a database backend (a process) which created the table. Oracle temporary tables are always defined within a user-specified ...

This looks like the sort of table that oracle might throw in automatically if you use Application Builder, but I haven't touched that for this user at all, even though I did play with it under the ...

Temp table -temporary temp tables1)they can be created at run time in tempdb database.2)ddl,dml statements like select,update which can be executed on regular tables can be done on temporary tables.

identifies the ORACLE table that you want to create. The TABLE= statement is required. The ORACLE-table-name argument can be up to 30 characters long and must be a valid ORACLE table name. If the ...

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored procedure.<BR ...