Temporary Table Problem [message #19374] |
Wed, 13 March 2002 09:45 |
uma
Messages: 67 Registered: May 2001
|
Member |
|
|
I have created one temporary table Yesterday by using this query.
CREATE GLOBAL TEMPORARY TABLE INSPCOPY ON COMMIT PRESERVE ROWS AS SELECT * FROM
INSPECTION_TYPE
But this table is stay even today. Is this table not session specific? Means when you signed off it won't go away.
Thanks,
Uma
|
|
|
|
Re: Temporary Table Problem [message #19379 is a reply to message #19374] |
Wed, 13 March 2002 11:30 |
uma
Messages: 67 Registered: May 2001
|
Member |
|
|
Thanks. Looks like a view .
In that case, how to create some work tables? I don't want to keep these tables be cataloged but I want to create in the process but I don't want to keep them forever.
For example If I want to populate one target table and I have mulitiple tables table1, table2, table3 as my sources then I want to combine table1, table2 data to a work table 1 then I want to combine worktable1 to table3 to populate my target table. Is there any way to do this?
Thanks,
Uma
|
|
|