¡¡¡¡ÇëÎÊÔÚoracle9iÀÔõÑùÏëǶÈë±íÀï²åÈëÊý¾ÝºÍÐÞ¸ÄǶÈë±íµÄÊý¾Ý£¬Ð»Ð»£¬ÎÒÃþË÷Á˺ó¤Ê±¼ä£¬²»µÃÃŵÀ¡£oracle8iµÄ²Î¿¼ÊéÀïµÄÓï¾äÔÚoracle9iÐв»Í¨£¬Çë¸÷λָµã¡£
¡¡¡¡create table test(a varchar2(10), b nested_tab_test) nested table b store as test1;
¡¡¡¡Ê×ÏÈÒª²åÈëÒ»¸ö¿ÕµÄǶÌ×±íÀàÐÍÖµ¡£
¡¡¡¡insert into test(a,b) values('aaa',nested_tab_test());
¡¡¡¡²åÈë¾ßÌåÖµ
¡¡¡¡insert into table (select b from test where a='aaa') values('a01');
¡¡¡¡Èç¹ûÊÇ´Ó±ðµÄ±í²åÈëÊý¾Ý¿ÉÒÔÕâô²Ù×÷¡£
¡¡¡¡insert into test select 'aaa',cast(multiset(select a from test2 ) as nested_tab_test) from dual;
¡¡¡¡ÖصãÊÇ°ÑÎÕ²åÈëÒ»¸öǶÌ×±í¶ÔÓ¦µÄÀàÐͶÔÏó¡£