Re: And again: 1NF may not be dead

"Tony Andrews" <andrewst_at_onetel.com> wrote in message news:1098892770.160831.229990_at_z14g2000cwz.googlegroups.com...
> Kenneth Downs wrote:
> > Does Oracle's language do such things?
>
> Yes, for arrays and nested tables:
>
> SQL> create table t (name varchar2(10));
> SQL> create type name_tab_type as table of varchar2(10);
> 2 /
> SQL> declare
> 2 name_tab name_tab_type := name_tab_type ('abc','xyz','123');
> 3 begin
> 4 insert into t select * from table(cast(name_tab as
> name_tab_type));
> 5 end;
> 6 /
> SQL> select * from t;
>
> NAME
> ----------
> abc
> xyz
> 123

Do you know what the output is in Oracle if you select * from t if you have both this relation and another nested in t? In other words, is there a select that could give you ouput like this:

John Doe (123) 555-1234 jdoe_at_msn.com

                 (232) 555-2837 john_doe_at_aol.com
                                          jd_at_johndoe.org

I looked at their enhancements to SQL a little a year ago and didn't get to the point where I knew how to do this.
Thanks. --dawn Received on Thu Oct 28 2004 - 02:45:29 CEST