All Forums Database
rediff123 14 posts Joined 02/09
28 Oct 2009
Global temporary table

How to create a GTT from another tableis it likecreate 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?

Jimm 298 posts Joined 09/07
29 Oct 2009

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.

You must sign in to leave a comment.