Home » SQL & PL/SQL » SQL & PL/SQL » Option for Temp table (10.2.0.4.0)
Option for Temp table [message #444150] Thu, 18 February 2010 22:12 Go to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
What is the Best option for SQL/sybase server Temp table to use/for data manipulation (Insert/update/delete) inside the procedure in oracle Other then global temporary table.

Since we are porting from SQL/Sybase to Oracle we don't want to Create too many global temporary table.

-Rahul



Re: Option for Temp table [message #444151 is a reply to message #444150] Thu, 18 February 2010 22:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
More often than not, Oracle does not require GTT or any type of "TEMP" table to provide desired result set.
Re: Option for Temp table [message #444156 is a reply to message #444150] Thu, 18 February 2010 23:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Since we are porting from SQL/Sybase to Oracle we don't want to Create too many global temporary table.

Porting is not an option, you have to rewrite the application.
Not only the usage of temporary table but many things like locking and concurrency are different in Oracle and programs need to be write for the target rdbms.
For instance, in Sybase procedure commit frequently even if there is no modification to prevent for readers blocking other readers or writers. In Oracle, you do not commit inside a procedure, you let the caller do it when it needs/wants it (or even rollback if it thinks the job done by the procedure is not interesting).
These are 2 different way to design the program, you cannot just convert from one language to the other one. The whole program has to be review in its structure.

Regards
Michel
Re: Option for Temp table [message #444160 is a reply to message #444150] Fri, 19 February 2010 00:06 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Thanks Michel & BlackSwan ,
Quite crisp and Clear.



Previous Topic: Trying to create a Counter for the number of inserts run in a block
Next Topic: reference to learn PL / SQL in oracle for beginners (merged by CM)
Goto Forum:
  


Current Time: Wed Feb 19 01:59:39 CST 2025