OraFAQ Forum: Forms » How to Insert and Update from Global temporary table ??

Home » Developer & Programmer » Forms » How to Insert and Update from Global temporary table ?? (Oracle 10g Forms)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Insert and Update from Global temporary table ?? [message #584572]

Wed, 15 May 2013 11:34

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

Report message to a moderator

Re: How to Insert and Update from Global temporary table ?? [message #584573 is a reply to message #584572]

Wed, 15 May 2013 11:52

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Direct answer: use MERGE.
Good question: why do you use GTT?

Regards
Michel

Report message to a moderator

Re: How to Insert and Update from Global temporary table ?? [message #584669 is a reply to message #584573]

Thu, 16 May 2013 12:32

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.

Report message to a moderator

Re: How to Insert and Update from Global temporary table ?? [message #584673 is a reply to message #584669]

Thu, 16 May 2013 13:00

John Watson
Messages: 8964
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.

Report message to a moderator

Re: How to Insert and Update from Global temporary table ?? [message #584690 is a reply to message #584669]

Thu, 16 May 2013 16:53

cookiemonster
Messages: 13963
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 19:04:15 CST 2025