|
|
|
Re: How to Insert and Update from Global temporary table ?? [message #584673 is a reply to message #584669] |
Thu, 16 May 2013 13:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:ahamed101
Because multiple user insert & update at the same time. GTT is working like as session. Are you sure this is the way to do it? It sounds to me very like the way Microsoft programmers work, when they need read consistency and transaction isolation: zillions of temporary tables, because SQL Server has trouble with this. You don't need to do that in an Oracle database.
|
|
|
Re: How to Insert and Update from Global temporary table ?? [message #584690 is a reply to message #584669] |
Thu, 16 May 2013 16:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
ahamed101 wrote on Thu, 16 May 2013 18:32Because multiple user insert & update at the same time. GTT is working like as session.
Forms is session specific though. So again - why do you need a GTT?
The fact that lots of users are inserting and updating at the same time shouldn't matter.
|
|
|