Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need SQL Server Temp Table equivalent (challenge!)
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.
![]() |
![]() |