Home » SQL & PL/SQL » SQL & PL/SQL » tempory table
tempory table [message #8633] Tue, 16 September 2003 05:01 Go to next message
Bipul
Messages: 11
Registered: June 2003
Junior Member
how to create tempory table in pl/sql and insert values inside and store.

i need code for that.
Re: tempory table [message #8639 is a reply to message #8633] Tue, 16 September 2003 09:47 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
quote from Bipul:
----------------------------------------------------------------------
how to create tempory table in pl/sql and insert values inside and store.

i need code for that.

----------------------------------------------------------------------
Back up a minute, Bipul.

What exactly are you trying to do?

Your request is common of people who come from a Microsoft SQL Server background. There's absolutely nothing wrong with that approach in SQL Server, but in Oracle, there are different/more efficient paths for doing these kinds of tasks. For example, in Oracle, DDL like defining tables should be performed *once*, not once per execution of code.

If you outline your business requirements for us, and maybe give some pre-existing table definitions, Bipul, we will be able to go a lot further in helping you solve your particular problem.

A.
Previous Topic: MERGE problem with FORALL on 9.2
Next Topic: Reg:Size of the table......
Goto Forum:
  


Current Time: Thu Mar 28 08:28:43 CDT 2024