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>
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