ºìÁªLinuxÃÅ»§
Linux°ïÖú

ǶÈë±íÀï²åÈëÊý¾ÝºÍÐÞ¸ÄǶÈë±íµÄÊý¾Ý

·¢²¼Ê±¼ä:2006-09-12 09:21:17À´Ô´:ºìÁª×÷Õß:maya_human
¡¡¡¡ÇëÎÊÔÚ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;

¡¡¡¡ÖصãÊÇ°ÑÎÕ²åÈëÒ»¸öǶÌ×±í¶ÔÓ¦µÄÀàÐͶÔÏó¡£
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ