|
|
|
Junior Member
 
Group: Forum Members
Last Login: 11/11/2009 1:12:32 PM
Posts: 14,
Visits: 39
|
|
How to create a GTT from another table
is it like
create global temporary table as
(sel * from employee)
on commit preserve row;
if i do this, the syntax error: something expected between ')' and 'on'
what is the mistake?
-Thank you
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 3:55:54 AM
Posts: 111,
Visits: 263
|
|
create global temporary table t1 as
(sel * from employee)
WITH NO DATA --------------------------
on commit preserve row;
Are you sure you want a Global table, not a volatile?
If the definition of Employee changes, you get the definition of employee as it was when the global temporary definition was created, not as it is now.
|
|
|
|