Home » Developer & Programmer » Forms » How to Insert and Update from Global temporary table ?? (Oracle 10g Forms)
icon5.gif  How to Insert and Update from Global temporary table ?? [message #584572] Wed, 15 May 2013 11:34 Go to next message
ahamed101
Messages: 2
Registered: May 2013
Location: Bangladesh
Junior Member
Global temporary Table Name:
1.MT_GBL
2.DT_GBL
3.DT2_GBL

Base Table Name:
1.MT
2.DT
3.DT2

My Steps:
1.Insert all data from global table to base table.
2.Update all data (that means retrieved all data from base table to global table and update this data).
Question: How to Insert and Update from Global temporary table ??
please help
Re: How to Insert and Update from Global temporary table ?? [message #584573 is a reply to message #584572] Wed, 15 May 2013 11:52 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Direct answer: use MERGE.
Good question: why do you use GTT?

Regards
Michel
Re: How to Insert and Update from Global temporary table ?? [message #584669 is a reply to message #584573] Thu, 16 May 2013 12:32 Go to previous messageGo to next message
ahamed101
Messages: 2
Registered: May 2013
Location: Bangladesh
Junior Member
Because multiple user insert & update at the same time. GTT is working like as session.
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 messageGo to next message
John Watson
Messages: 4859
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
cookiemonster
Messages: 11285
Registered: September 2008
Location: Rainy Manchester
Senior Member
ahamed101 wrote on Thu, 16 May 2013 18:32
Because 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.
Previous Topic: WUT-116 [WEBUTIL_FILE_TRANSFER.UploadInt] Transfer already in progress
Next Topic: using forms 6i :map the excel columns and insert it in oracle table
Goto Forum:
  


Current Time: Fri Dec 19 18:54:18 CST 2014

Total time taken to generate the page: 0.10466 seconds