Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need SQL Server Temp Table equivalent (challenge!)

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

From: tojo <Tojo_at_hotmail.com>
Date: Mon, 28 Jul 2003 12:43:42 +0200
Message-ID: <MPG.198f1cca6fd33ee1989699@news.t-online.de>


In article <d5b3f600.0307260133.7fe610d4_at_posting.google.com>, kin_ng5 @yahoo.com says...
> Karsten,
>
> I actually handled my problem using .NET's DataTable where I can
> create any columns on the fly and display to the users. i.e. similar
> to the temp table solution. While the solution works but I would like
> a similar solution written in PL/SQ or View or anything that's in the
> DB. Please take a look at Galen Boyer's suggestion in this thread. I
> tried that and indeed I was able to do what I wanted. The performance
> was not too bad also.
>
> Thanks all for the genuine helps.
>
> Kin
>

If you truly have a changing structure, why don't use just write a stored proc that returns XML as a string? You can then create your DataTable (or DataSet even) based on the XML.

Received on Mon Jul 28 2003 - 05:43:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US