tempory table [message #8633] |
Tue, 16 September 2003 05:01 |
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 |
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.
|
|
|