Hi,

I have a requirement to remove MULTISET from the SQL queries.

Please suggest some alternative ways in which I can implement my queries
without MULTISET.

Any help will be greatly appreciated.

Thanks and Regards,
Meenu Thapliyal

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Thu, Jun 17, 2010 at 7:47 AM, meenu sharma <meenu.thapliyal (AT) gmail (DOT) com>wrote:

What are you using MULTISET for? If you are using it to simiulate derived
tables as in SELECT ... FROM TABLE(MULTISET(SELECT....)), and you are
running 11.50, you can just use derived tables as in: SELECT ... FROM
(SELECT ...), though I can think of VERY few queries that are written using
derived tables that couldn't be rewritten as a simple join! And they
usually perform better that way. The only derived table queries I know of
that can't be rewritten as a join are those where the subquery returns
aggregates and you want to join the aggregates to non-aggregated rows or
aggregates at different levels.

Art

Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Thu, Jun 17, 2010 at 7:47 AM, meenu sharma <meenu.thapliyal (AT) gmail (DOT) com>wrote:

Thanks Art !!

Yeah the queries are in thhis form only. Thanks for your suggestion, I will
try to use Join for these queries.

Thanks for your reply.

Regards,
Meenu

On Thu, Jun 17, 2010 at 10:25 PM, Art Kagel <art.kagel (AT) gmail (DOT) com> wrote: