Re: And again: 1NF may not be dead
From: Tony Andrews <andrewst_at_onetel.com>
Date: 27 Oct 2004 08:59:30 -0700
Message-ID: <1098892770.160831.229990_at_z14g2000cwz.googlegroups.com>
abc
xyz
123 Received on Wed Oct 27 2004 - 17:59:30 CEST
Date: 27 Oct 2004 08:59:30 -0700
Message-ID: <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 Received on Wed Oct 27 2004 - 17:59:30 CEST