SQL Language (MOSC)

MOSC Banner

Insert into Global Temp Table

edited Jan 21, 2014 3:24PM in SQL Language (MOSC) 7 commentsAnswered
I am executing an INSERT into a global temp table.   If I execute the insert using a list of values (INSERT INTO gtt <...> VALUES <...>) then the insert performs successfully.  However, if I execute the insert using a SELECT statement (INSERT INTO gtt <...> SELECT <..>) then I get 0 rows inserted.  I have executed the SELECT statement by itself and confirmed that 1 rows is actually returned, so I would expect one row to be inserted into the global temp table when the INSERT is executed.   Is there something special that has to be done in order to

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center