nest and unnest operators

From: Kanda Runapongsa <krunapon_at_umich.edu>
Date: Sun, 12 Nov 2000 18:25:08 -0500
Message-ID: <3A0F26D4.D7C96E86_at_umich.edu>


Dear there,

   Do nest and unnest operators available in Oracle?

    For example, if I have

        SPEECHID                SPEECH_SPEAKER
        1                       <SPEAKER>A</SPEAKER><SPEAKER>B</SPEAKER>


        -------------------
        I want to have a result as follows which I think we then need an

unnest operator

        SPEECHID                SPEECH_SPEAKER
        1                       <SPEAKER>A</SPEAKER>
        1                       <SPEAKER>B</SPEAKER>
        --------------------

       Thank you very much.

-Kanda Received on Mon Nov 13 2000 - 00:25:08 CET

Original text of this message