Re: Need SQL Server Temp Table equivalent (challenge!)

#1

Kin Ng wrote:

Quote:

"Anurag Varma" <avarmadba.skipthis (AT) yahoo (DOT) com> wrote

stop posting same messages in different oracle newsgroups.
Its a waste of bandwidth and other people's time.

Anurag

Sorry. I didn't know which group should I post to for this kind of
question. Frankly I was hoping more people can see this as I saw lots
of "you don't need temp table" statement but couldn't find any
solution for my real need.

c.d.o.marketplace ... things you are buying or selling
c.d.o.server ... things related to Oracle RDBMS server
c.d.o.tools ... things related to Forms, Reports, Designer, Discoverer, JDeveloper, etc.
c.d.o.miscellaneous ... everything else

Never cross-post unless you intent to make people cross.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

#2

"Kin Ng" <kin_ng5 (AT) yahoo (DOT) com> wrote

Quote:

I have a need to create a temp table for a session only. The temp
table's structure is not fixed. Thus the current Oracle temp session
table won't work.

Well you can create tables using dynamic SQL but if you don't intend to
store this data in permanent tables, then I would have thought that an array
(PL/SQL table ) would do you fine. If you do intend to permanently store the
data (and if you don't why are you using an RDBMS) then make sure you get an
appropriate ER diagram done and the appropriate structure should fall out.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

#3

"Niall Litchfield" <n-litchfield (AT) audit-commission (DOT) gov.uk> wrote

Quote:

"Kin Ng" <kin_ng5 (AT) yahoo (DOT) com> wrote in message
news:d5b3f600.0307121142.3465010 (AT) posting (DOT) google.com...
I have a need to create a temp table for a session only. The temp
table's structure is not fixed. Thus the current Oracle temp session
table won't work.

Well you can create tables using dynamic SQL but if you don't intend to
store this data in permanent tables, then I would have thought that an array
(PL/SQL table ) would do you fine. If you do intend to permanently store the
data (and if you don't why are you using an RDBMS) then make sure you get an
appropriate ER diagram done and the appropriate structure should fall out.

"Well you can create tables using dynamic SQL " This is not allowed as
we did follow the recommendation of our good data modeler. i.e. We
have a good ER diagram and it didn't solve problems like that.

Can you give an example of how an Array can be returned to the users
via a view?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Need SQL Server Temp Table equivalent (challenge!)

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Need SQL Server Temp Table equivalent (challenge!) - 07-13-2003 , 06:05 PM

Re: Need SQL Server Temp Table equivalent (challenge!) - 07-14-2003 , 03:02 AM

Re: Need SQL Server Temp Table equivalent (challenge!) - 07-14-2003 , 02:04 PM